Share via

Finding Partial Match in Two Different Columns in Excel

Anonymous
2020-07-03T13:47:55+00:00

I need to find a partial match in two different columns in excel, then highlight the values. Once the values are highlighted I need to be able to filter the results. If you use conditional formatting, highlight duplicate value rule it only captures exact matches. As you can see some of my values have a "-" in them and using the conditional formatting it doesn't highlight those values.

The two column I need compared are A and F, values won't match by row. I could have a 361569 (A61) in column F in a totally different row.

Anyone have any ideas how to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-03T14:24:38+00:00

    What exact formula would I use for that? I'm not great with excel.

    Thanks.

    0 comments
  2. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-07-04T08:19:43+00:00

    What exact formula would I use for that? I'm not great with excel.

    Have a look into this sample file:

    https://www.dropbox.com/s/k94srr9t3693gfh/bdb78dfc-b0d0-4aaf-babc-1aa59f8e1248.xlsx?dl=1

    Andreas.

    1 person found this answer helpful.
    0 comments