Forum Discussion
Solved
Find latest value by searching right to left - formula
Don’t suppose anyone can help with a formula please? I am trying to find a "first" and "last" sale date. I’ve achieved the first sale date by using this formula below, now I essentially want it to do...
As an array formula confirmed with Ctrl+Shift+Enter:
=INDEX($B$4:$IV$4,MAX(($B5:$IV5>0)*ISNUMBER($B5:$IV5)*(COLUMN($B$4:$IV$4)-COLUMN($B$4)+1)))
As an array formula confirmed with Ctrl+Shift+Enter:
=INDEX($B$4:$IV$4,MAX(($B5:$IV5>0)*ISNUMBER($B5:$IV5)*(COLUMN($B$4:$IV$4)-COLUMN($B$4)+1)))
This is perfect! thank you so much