0

In excel, after I search and click "find all", I want to see the matching adjacent column values in the results list (so I can compare them).

Is there a way for me to archive something like this? Or perhaps a software that does this?

Thanks!

2
  • Highlight duplicates and then sort ascending. No need to find. Feb 12, 2015 at 19:00
  • I like to use the VLOOKUP function. If the result returns #N/A then I know there is no match.
    – BillDOe
    Feb 12, 2015 at 20:04

1 Answer 1

0

Rather than use Search, consider using AutoFilter to "find" relevant data. That way the entire row is visible and you can easily see any adjacent column.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .