I'd create a new worksheet and copy all the data into one column. Then I'd use
data|filter|Advanced filter to extract just the unique records.

Debra Dalgleish explains the data|filter|advanced filter stuff at:
http://www.contextures.com/xladvfilter01.html#FilterUR

If your combined list is too large, you can use advanced filter on each column
and then merge those unique records together and do one more advanced filter.

wammer wrote:

I have similar data in multiple columns and I want to filter on all
columsn togather to get unique values. Is there a good way to do so.

--
wammer
------------------------------------------------------------------------
wammer's Profile: http://www.excelforum.com/member.php...o&userid=12452
View this thread: http://www.excelforum.com/showthread...hreadid=399224

--

Dave Peterson