How to filter data to show similar entries in a worksheet.

[Tony Clark]

I NEED HELP!! I know how to filter out unique records in a
worksheet, but I need to know how to filter the contents of
two columns which contain several cells of the same data. I
want to know if it is possible to filter both columns to
show only those cells that contain the same data. Thanks in
advance for any help.

 

[Debra Dalgleish]

Chip Pearson has instructions for finding and tagging duplicates in a list:

http://www.cpearson.com/excel/duplicat.htm

However, you can only have one filter per worksheet, so you won't be
able to filter the columns separately, if that's what you're trying to do.