Find First Cell Value

This is a way that I thought up (but I may not be the first)

In B1 enter =IF(A1="","",ROW()) and drag down

Then in C1 enter =INDEX(A:A,MIN(B:B))


For a range such as A1:A100, use this formula


Must be entered as an array. (Push Ctrl, Shift and Enter simultaneously)

© Copyright All Rights Reserved.