Forum Discussion

ClauP's avatar
ClauP
Copper Contributor
Mar 21, 2019

Help me create a formula which erases or hides non-identical values, please.

Detlef_Lewin, SergeiBaklan

Hello 

Can you please help create a formula again which erases or hides non-identical values after each other.

I have attached an example of what I want to achieve.

Thank you.

This forum is really great, I got help within some hour of posting another question. Really good community. 

BR/Claudiu

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 22, 2019

    Hi Claudiu,

     

    For that sample

    you may use in A31

    =IFERROR(INDEX(A$2:A$14,AGGREGATE(15,6, 1/(COUNTIF($A$2:$A$14,$A$2:$A$14)>1)*(ROW($A$2:$A$14)-ROW($A$1)),(ROW()-ROW($A$30)))),"")

    and drag it down and to the right. Adjust ranges for your real data.

Resources