Snasui Excel Forum

Hi there,

I can create a helper column then sort to insert one row below each dups.here I want a formula to skip one row every each dups.

TY

I attach a sample as well

Try this

Cell B2

=IFERROR(IF(COUNTIF($A$2:$A$15,B1)=COUNTIF(B$1:B1,B1),"",INDEX($A$2:$A$15,ROWS($B$2:B2)-COUNTIF(B$1:B1,""))),"")

Enter and copy down.

Thank you