lifeson said:Does anybody know what formula to use in excel to return the row number of a row that contains specific data in column A
Column "A" contains unique IDs (Pay numbers)
I want a formula that tellls me which row contains pay no 1234:confused:
hmmm... maybe they don't. I vaguely remember reading it though, maybe it was something else.simon_adams_uk said:Add a new column to the right of the column which contains the unique pay number IDs. This new column should be numbered from 1 to n.
For this example they're columns A (Pay number IDs) and B (row number) and you've got 100 records (ie 100 rows).
If you enter a formula along the lines of
will give you the row number for ID 1234
Instead of typing '1234' you can softcode this to another cell value.
I disagree with Bonj that the pay number IDs have to be in order - as long as they are unique it shouldn't matter.