Juniad
Do You mean like Your C... ? ... Isn't that show 'Feb' for an answer?
and
... You have written about 'last value'
... ... isn't 'last value' the value, which You've put there the last?
Veltm:
this formula is not giving correct answer..
=INDEX(B$1:E$1,1,MATCH(MAX(B2:E2),B2:E2,0))
is is looking max value in row and giving same column header..
Example if i enter max value before the last value in row.. then result will not correct .. because i want the column header based on last value in row ever.
See in the screen short, in row 5 my last value is 3 in E column.. and answer should be April.. but it is looking max value which is in B5 and giving result Jan
BTW i tried this formula but problem is if there is duplicate value in row then match is giving 1st match result ..
=INDEX($B$1:$E$1,MATCH(LOOKUP(2,1/(B4:E4>0),B4:E4),B4:E4,0))
Juniad
Although, You sentence is not a question ... I try to answer.
Actually, there are formulas in that file. .. I'm not sure what did You mean...?
Do it work?
Juniad
Although, You sentence is not a question ... I try to answer.
Actually, there are formulas in that file. .. I'm not sure what did You mean...?
Do it work?
Juniad
Formulas
1) ... are not on sheet!
2) that my sample need to be .xlsb-format
Test to fill values Yourself, I tested and it seems to give Your needed results.