Finding the Row number based on contents of a cell
 

I would like to find the row number of a cell based on it contents. In
other words, search a column for a particular value and then find the
row number.

Is there an easy way to do this?

TIA

Chris

Finding the Row number based on contents of a cell
 

U can use the Match formula, for more detail u can get form the office help
..i.e. =match(a1,column,0)
Regars
Sebation.G

"Chris Youlden"
...
I would like to find the row number of a cell based on it contents. In
other words, search a column for a particular value and then find the row
number.

Is there an easy way to do this?

TIA

Chris

Finding the Row number based on contents of a cell
 

Hello Chris
As mentionned by chelsea, you may use the MATCH function but this will work
if your data starts at line 1.
If it doesn't, you can try this formula (amend references and criteria
accordingly):
=IF(MATCH("Criteria",A5:A13,0)<ROW(A5),MATCH("Crit eria",A5:A13,0)+(ROW(A5)-1),MATCH("Criteria",A5:A13,0))

But I am sure someone will have a better looking formula ;-)

HTH
Cordially
Pascal

"Chris Youlden" a écrit dans le message de news:
...
I would like to find the row number of a cell based on it contents. In
other words, search a column for a particular value and then find the row
number.

Is there an easy way to do this?

TIA

Chris

Finding the Row number based on contents of a cell
 

Thanks to both of you. I didn't realise MATCH would return the cell
reference.

regards

Chris

Finding the Row number based on contents of a cell
 

Chris
MATCH does NOT return a cell reference.
It returns the position of the criteria found.

HTH
Cordially
Pascal

"Chris Youlden" a écrit dans le message de news:
...


Thanks to both of you. I didn't realise MATCH would return the cell
reference.

regards

Chris

Finding the Row number based on contents of a cell
 

papou wrote:
Chris
MATCH does NOT return a cell reference.
It returns the position of the criteria found.



Ah, yes, of course. As my data is only in one column I was fooled by that!

thanks

Chris