Advanced data filter

[rasonline]

Good day all

having some problems with advanced data filter. i've had a read of these threads but the solutions don't seem to help on my workbook.

http://www.excelforum.com/excel-gene...nd-delete.html
post #5 seems to have a solution but i don't understand what is going on there.

http://www.excelforum.com/excel-prog...ml#post2054885

Attached is a worksheet of dummy data with what i want to achieve. I've displayed 3 columns, each with a header and data in the various rows. Need to pull the unique entries across the whole range of data.

If i highlight all 3 columns and try to run an advanced filter ont he range, then it still shows me way too many entries.

I've shown the solution that i want it to result in. In order for me to have shown this, i ran a data filter on each column individually. Then combined those results into one column, and ran another data filter. My full database has 30 columns, so i can't do this for the full list of data.

thanks in advacne.

[martindwilson]

found this code seems to work ok put in a new module then run
first pop up window highlight range
second pop up window just select an entire spare column

Please Login or Register  to view this content.