Hello Everyone,
Using Excel 2010.
I have a worksheet that has 7 columns (A1:G20).
In column B there are dates and in column G there are numbers (not every row will have a number).
I am looking for the find the first number in G1:G20 and then find the corresponding date in B1:B20.
Attached is a sample worksheet. Need help writing a formula for this.
Thanks in advance.
Mike
Last edited by windme; 01-06-2011 at 03:21 PM.
Try:
=INDEX($B$1:$B$20,MATCH(TRUE,INDEX(ISNUMBER($G$1:$G$20),0),0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Once again NBVC you came through! Thanks so much for your expertise, it's really appreciated.
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks