Forum Discussion
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. Tha...
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.