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!
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!
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.