MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find row number of first occurance of data


Posted by Paul on January 22, 2002 4:06 AM

I have a sheet with items in for repair in different shops (Column C). The number of Items changes daily. I have a report that I print everyday that I need to find the first occurance of the 2nd shop ("415/N")to start the second part of my report. Any help would be appreciated.


Posted by Aladin Akyurek on January 22, 2002 4:24 AM

Paul --

=MATCH("415/N",C:C,0)

will return the row number of interest if 415/N exists in C, otherwise #N/A.

Aladin

==========

Posted by Paul on January 22, 2002 4:38 AM

That was too easy. Worked just the way I wanted. Thank you!!