Get column header - start and end date based on first and last value encounter in the ro
Hey Guys,
I am working on the excel sheet, in which i want the start date and last date based the value from the rows. If cell have encounter any value greater than zero, it will return the column header of the first value and last column header on that row range
Start Date End Date 23-Mar 30-Mar 06-Apr 13-Apr 20-Apr 27-Apr 04-May 11-May
0 0 1 3 4 5 0 0
0 0 2 4 2 5 0 0
Screenshot_1.jpg
Start:
=INDEX($C$1:$N$1,MATCH(TRUE,INDEX((C2:N2<>0),0),0))
End
=LOOKUP(2,1/(C2:N2<>0),$C$1:$N$1)
See sheet. Next time, please attach a sample sheet, not a non-editable picture of one. See yellow banner (top of page) for instructions.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks