Return the Row a certain Value in Excel

I have a spreadsheet (.xls). In column A, there are several unique numeric values ranging from 0001-9999. After 9999, there are a series of 0's continuing to display in the column. In cell "B2", i would like to capture the actual row the 0's began to appear. So for example, if in A1 through A9999, there were actual values, then in Cell A10000, theres the first 0, i would like for "10000" to calculate/ populate in cell B2. I'm open to simple excel formula or VB to run module.

Any takers?
ctownsen80Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
barry houdiniConnect With a Mentor Commented:
For the position of the first zero in column A try MATCH function, i.e. in B2 use this formula

=MATCH(0,A:A,0)

regards, barry
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

like this maybe?

=MATCH(0,A:A,-1)

cheers, teylyn
0
 
ctownsen80Author Commented:
WORKS PERFECT! THANKS.
0
All Courses

From novice to tech pro — start learning today.