I want to compare the values of 2 columns with all rows in the sheet.

If there is a match I want to place a character in the next column, so I can filter on it

But I need to keep one row for each unique value. (match of 2 columns)

Re:  Match values of 2 columns

Have you reviewed the answers provided in your March 30, 2015 post ("Hide rows with same content in cell").

'---
Jim Cone
Portland, Oregon USA
free & commercial excel programs (n/a xls013)
https://jumpshare.com/b/O5FC6LaBQ6U3UPXjOmX2

Re:  Match values of 2 columns

Have you reviewed the answers provided in your March 30, 2015 post ("Hide rows with same content in cell").

'---
Jim Cone
Portland, Oregon USA
free & commercial excel programs (n/a xls013)
https://jumpshare.com/b/O5FC6LaBQ6U3UPXjOmX2

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 23 hours 13 minutes ago

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"