Need Help in worksheet functions

[leasaac]

I have a retail business and I usually download my orders details usin
an excel format to my pc. The orders details headings are as follows
First Name, Last Name, Address1, Address2, Country; Order Number.

The problem I am facing here is like this. For example:

Row 1- David; Cruz; 23 abc Strett; Chicago; USA; 1001
Row 2- David; Cruz; 23 abc Strett; Chicago; USA; 1001
Row 3- David; Cruz; 23 abc Strett; Chicago; USA; 1001
Row 4- Susan; Mary; 24 babylon; Los Angeles; USA; 1045
Row 5- Marcus; Peter; 98 coco road; Hawaii; USA; 1056
Row 6- Jones; Mark; 1 Mafia road; Maa; Italy; 1087

If you noticed, the file I downloaded have row 1-3 with the same name
The reason for this is because this customer order 3 items, whereas th
row 4-6 customers order only 1 item each. The typical daily orders i
about 100, rows will be about 140-180(Customers usually buy more tha
one item).

I want to remove those duplicate rows and show only one row for eac
order.

Is it possible create a script or something like that which ca
automatically delete away all the duplicate rows and show only on
order per row?

Any help is deeply appreciated.

Thank you in advance

 

[Govind]

Hi,

You can use filter-Advanced filter and copy the unique records alone to
another location and use that.

Regards

Govind.