Snasui Excel Forum

Hi Dear ,

I need your help how to write formula to get output in column B and C as in template attached.

Thank you

Ref:column B and C

...

B2
=IF(A2="","",IF(MATCH(A2,$A$2:$A$99,0)=1,A2,IF(A1="TOTAL",A2,"")))

C2
=IF(OR(A2="TOTAL",A2="",A3="TOTAL"),"",INDEX(A:A,LOOKUP(CHAR(255),$B$2:B2,ROW($B$2:B2))+1))

Norkaz

Thank you