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

Occasional Contributor

@Detlef Lewin@Sergei Baklan


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. 


1 Reply

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies