Home

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

Highlighted
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.

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