Forum Discussion
Solved
Excel formula help - vertical and horizontal in same calculation
Hello, I have a set of data that contains resource names and their FTE effort per month. I'm trying to calculate their start month and end month in two cells but can't get my head around the correct...
As variant
Start
=XLOOKUP(2,1/(E2:P2<>0),$E$1:$P$1,,-1)End
=LOOKUP(2, 1/(E2:P2<>0), $E$1:$P$1)
Alternatively for End date:
=XLOOKUP(TRUE,E2:P2>0,$E$1:$P$1,,,-1)
XLOOKUP can search from last to first (6th argument of the function).
XLOOKUP function - Microsoft Support