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!!
