Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locate a cell, based on a criteria, then use the 'Cell' command...
I am using a pivot table to configure some data. In the first column, the
pivot table of course displays only one instance of the text representing of data group. What I need to do is determine in which cell a particular item of text (i.e. the criteria) resides in. Once I can locate the cell where my 'criteria' text string resides, I can then use the CELL function to return the row number. My question is... what excel formula can I use to locate a cell in a single column range, where the cell contains the text = "XYZ" My eventual plan is to then use the following to return the row number where that text string reside: =CELL("Row",'cell found using above formula') Thanks for the help! Craig |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locate a cell, based on a criteria, then use the 'Cell' command...
Turns out basic use of the 'Match' function was all I needed.
Thanks anyway! "cdavidson" wrote: I am using a pivot table to configure some data. In the first column, the pivot table of course displays only one instance of the text representing of data group. What I need to do is determine in which cell a particular item of text (i.e. the criteria) resides in. Once I can locate the cell where my 'criteria' text string resides, I can then use the CELL function to return the row number. My question is... what excel formula can I use to locate a cell in a single column range, where the cell contains the text = "XYZ" My eventual plan is to then use the following to return the row number where that text string reside: =CELL("Row",'cell found using above formula') Thanks for the help! Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locate a Cell based upon criteria | Excel Discussion (Misc queries) | |||
How do I do multi VLOOKUP's based on certain criteria per cell? | Excel Worksheet Functions | |||
Can I select a worksheet based upon a cell criteria?(for printing) | Excel Worksheet Functions | |||
changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |