Snasui Excel Forum

Hi Dear

I need your help how to formula n solve the problem.
I have duplicate list in a table .
I need the result to retrieve only unique list and its values downward so it may have blank rows as in attached.

Best Wishes

...


A8

=IFERROR(IF(ROWS($8:8)>COUNTA($A$2:$A$5),"",INDEX($A$2:$A$5,IF(ROW(2:2)-ROW(2:2)/2=INT(ROW(2:2)/2),INT(ROW(2:2)/2),""))),"")

B8

=IF(ROWS($8:8)>COUNTA($A$2:$A$5),"",INDEX($B$2:$B$5,IF(ROW(2:2)-ROW(2:2)/2=INT(ROW(2:2)/2),INT(ROW(2:2)/2),INT(ROW(2:2)/2)+2)))

Does this help?

Norkaz

It works