Finding only distinct rows

Hi,

There is a data, which contains number of rows which are reapeted more than once.

The solution is to eliminate the repetion and find only the distinct rows.

For example:

Please Login or Register  to view this content.

In the above data "12,14,35" "32,19,18" "5,1,4" has repeated more than once, so the task is to exclude their duplicates and only display their,
single occurance along with other distinct rows.

After sorting the above data, it should should look like this:

Please Login or Register  to view this content.

Thanks

.
This is one way to accomplish the task :

Please Login or Register  to view this content.

I like the helper column solution, but it needs to be
D2=IFERROR(SMALL(A2:C2,1)&"-"&SMALL(A2:C2,2)&"-"&SMALL(A2:C2,3),"")

or something similar, otherwise 1, 2, 34 would match with 1,23,4

Originally Posted by davsth

I like the helper column solution, but it needs to be
D2=IFERROR(SMALL(A2:C2,1)&"-"&SMALL(A2:C2,2)&"-"&SMALL(A2:C2,3),"")

or something similar, otherwise 1, 2, 34 would match with 1,23,4

Yep. You're right. I forgot it. Tks.

cheers congnt92 , but what about the formula for rows F,G,H to also display the actual items from rows A,B,C, any idea about that?

Originally Posted by LAVA2

cheers congnt92 , but what about the formula for rows F,G,H to also display the actual items from rows A,B,C, any idea about that?

Hi Lava2
I don't know what you mean. Could u explain more details?