Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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.

Check out our Excel Resources

Re: Find row number of first occurance of data

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

==========


Re: Find row number of first occurance of data

Posted by Paul on January 22, 2002 4:38 AM
That was too easy. Worked just the way I wanted. Thank you!!


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.