Create a list of unique entries based on several columns

Use an advanced filter. There is an option to select unique data. You can filter in place or to another location.

http://www.dummies.com/how-to/conten...xcel-2013.html

It's best to place your attachment right here on this forum so I haven't looked at your file

However, take column F & concatenate columns A-E and then in column G...

=COUNTIF($F$2:F2,F2) >> copied down

filter for 1's and those are the uniques

Note: 2007 even has a built in Remove Duplicates >> Data >> Data Tools >> Remove Duplicates

This is probably not an option, but could you copy/move each column into 1 column, and then use "remove duplicates"?

On a side-note, please dont upload files to file-hosting sites like dropbox, not all members can access them (company firewalls and stuff), rather, upload them here...
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Why not just select the data then click on the Data tab, Remove Duplicates? If you still need the original data, select the data before removing duplicates and copy to another location. Then, remove the duplicates....quick and easy with no formulae or coding.

That wont remove duplicates if something else in that row is different to another row (already tried that)

The asker did want a list of all "unique" rows.

That wont remove duplicates if something else in that row is different to another row (already tried that) .... in that case the rows are not duplicates as I understand the term "duplicate" but are "unique". I wonder what it is that he really wants. Is he getting columns and rows mixed up?

Jeffreybrown's formula is interesting in this context in that it eliminates all rows that have been duplicated leaving only rows that never had a duplicate.

An example of expected output certainly would take the guess-work out of this.

another way in g4 =SUMPRODUCT(--(INDEX($B$3:B4&$C$3:C4&$D$3:D4&$E$3:E4&$F$3:F4,0)=B4&C4&D4&E4&F4)) filter on 1