Home

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

ClauP
Occasional Contributor

@Detlef Lewin@Sergei Baklan

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

1 Reply

Hi Claudiu,

 

For that sample

image.png

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.