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)
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)