Return the Row a certain Value in Excel
Posted on 2011-02-22
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.