E
Elton Law
Dear expert,
Say informationlike this ...
Cell A1
Leo, Patrick, Dion, Carmen
Cell A2
25,78,98,27
Call A3
Jenny, Yvonne, Kammi, Peter
Cell A4
Chrain, Ricky, Terence, Jamie
Can I use a function to search Kammi and return the column address in Cell
A5 please?
In this case, Kammi in A3. Cell A5 should show 5 as answer.
Can you advise how to do it please? Thanks indeed
Say informationlike this ...
Cell A1
Leo, Patrick, Dion, Carmen
Cell A2
25,78,98,27
Call A3
Jenny, Yvonne, Kammi, Peter
Cell A4
Chrain, Ricky, Terence, Jamie
Can I use a function to search Kammi and return the column address in Cell
A5 please?
In this case, Kammi in A3. Cell A5 should show 5 as answer.
Can you advise how to do it please? Thanks indeed