Forum Discussion
Help me create a formula which erases or hides non-identical values, please.
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
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.
