remove identical data entries

[ed]

The spreadsheet iam using has three columns for co-
ordinate values (x,y,z). I would like to be able to
remove the data entries that are the duplicated ie. they
have the same x,y,&z value, so that there is only one set
of co-ordinates with those values.
I have not be able to find a way of doing this yet.
Any suggestions would be greatly appreciated.

 

[Max]

Try one way using advanced filter:

Assuming the x-y-z coords are in cols A - C,
labels in row1, data from row2 down

Put

in D1: xyz (just a label)

in D2: =A2&B2&C2

copy D2 down col D
until the last row of data in cols A - C

Click & place the cursor anywhere inside the data area

Click Data > Filter > Advanced Filter

In the Advanced Filter dialog box:
----------------------------------------
Check "Copy to another location"

Click to put the cursor inside the box for "Copy to:"
then click outside on say, cell E1

Check "Unique records only"

Click OK

The unique records will be returned in cols E - H