Hi All,
I'm looking for a forumla to be able to determine the date from 1st row of the excel (header) based on the data in the rows below.
Have attached the excel data sample along with the required result in Colum Q. Bassically, I need to get the date in every row where the first value greater than 0appears.
Look forward to your assistance!
Thank you!
jai.anand@aol.in,
Using your provided workbook, in cell Q2 and copied down:
=INDEX($B$1:$P$1,MATCH(TRUE,INDEX(B2:P2>0,),0))
If the numbers can only be 1 or 0 as implied, then this simplified version will work:
=INDEX($B$1:$P$1,MATCH(1,B2:P2,0))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
This worked brilliantly. Thanks!
Closing it as "solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks