| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the cell content
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the cell content
I'm not sure why you expect a 5 in A5 when Kammi is in A3 (was that a
typo?), but if you put this in A5: =MATCH("*Kammi*",A1:A4,0) then it will return 3. Note the use of asterisks, which are wildcard characters. Hope this helps. Pete On Dec 19, 3:28*pm, Elton Law wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the cell content
Hi Pete ...
Yes yes .. that works Field should be A1:D1 ... Anyway, yours works. Thanks indeed. =MATCH("*kammi*",A1:D1,0) "Pete_UK" wrote: I'm not sure why you expect a 5 in A5 when Kammi is in A3 (was that a typo?), but if you put this in A5: =MATCH("*Kammi*",A1:A4,0) then it will return 3. Note the use of asterisks, which are wildcard characters. Hope this helps. Pete On Dec 19, 3:28 pm, Elton Law wrote: 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 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the cell content
You're welcome - thanks for feeding back.
Pete On Dec 19, 5:34*pm, Elton Law wrote: Hi Pete ... Yes yes .. that works Field should be A1:D1 ... Anyway, yours works. Thanks indeed. =MATCH("*kammi*",A1:D1,0) "Pete_UK" wrote: I'm not sure why you expect a 5 in A5 when Kammi is in A3 (was that a typo?), but if you put this in A5: =MATCH("*Kammi*",A1:A4,0) then it will return 3. Note the use of asterisks, which are wildcard characters. Hope this helps. Pete On Dec 19, 3:28 pm, Elton Law wrote: 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 .- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the cell content
OOh Sorry. I describe wrongly.
Should be Say informationlike this ... Cell A1 Leo, Patrick, Dion, Carmen Cell B1 25,78,98,27 Call C1 Jenny, Yvonne, Kammi, Peter Cell D1 Chrain, Ricky, Terence, Jamie Can I use a function to search Kammi and return the column address in Cell E1 please? In this case, Kammi in C1. Cell C1 should show 3 as answer. Can you advise how to do it please? Thanks indeed "Elton Law" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
