Dear Experts,

                   Greetings!

                   I have a data like below(A1:E17), In Column “F” , I need an output like this:-

Tried with IF, but too lengthy.. could you please share some other formula to achieve this..

Something like FILTER, INDEX MATCH etc..

Thanks in Advance,

Br,

Anupam

​Dear Experts,                   Greetings!                   I have a data like below(A1:E17), In Column “F” , I need an output like this:-Tried with IF, but too lengthy.. could you please share some other formula to achieve this.. Something like FILTER, INDEX MATCH etc.. Thanks in Advance,Br,Anupam   Read More

​