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:
A1 B1 C1
12 14 35
14 35 12
6 18 27
32 19 18
32 19 18
16 17 14
5 1 4
5 1 4
1 5 4
22 14 11
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:
D1 E1 F1
12 14 35
6 18 27
32 19 18
16 17 14
5 1 4
22 14 11
Thanks
Bookmarks