Finding the Row number based on contents of a cell

  • Thread starter Thread starter Chris Youlden
  • Start date Start date
C

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
 
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
 
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("Criteria",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
 
Thanks to both of you. I didn't realise MATCH would return the cell
reference.

regards

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

HTH
Cordially
Pascal
 
papou said:
Chris
MATCH does NOT return a cell reference.
It returns the position of the criteria found.
Click to expand...


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

thanks

Chris
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Count rows based on multiple criteria 3
one cell in a row contains a number 7
How do I return a cell contents in a large worksheet? 3
Formula Based on Multiple Sheets 5
How can I automatically color a row based on cell content 1
use cell address 1
Reference the same cell based on tab name 1

Back
Top