Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
Find a cell's content in another cell but only as whole word(s) | Excel Worksheet Functions | |||
how to find and replace content of a specific cell based on its ad | Excel Discussion (Misc queries) | |||
How to Find/Replace * (asterisk) in cell content | Excel Discussion (Misc queries) | |||
Excel find the content of cell using row and column header | Excel Worksheet Functions |