Find and Replace - Adjacent Columns

[kimizito]

Hello.

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 the results).

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

Thanks!

 

[Rick Rothstein]

Hello.

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 the results).

Is there a way for me to archive something like this?

I think using the AutoFilter functionality of Excel may allow you to do what I think you are describing you want to do. Select the column you want to search in, then select the Data tab on the Ribbon and in the middle is an icon that (is supposed to) look like a funnel with the word "Filter" under it... click that button. If you look at the first cell in the column you selected, you will see a drop down arrow... click it and uncheck all the check boxes (you can do that by click the first check box labeled "Select all"), then put a checkmark in whichever item you want to look at and then click OK.