Excel conflict list sorting

[amadtaz]

I'm struggling to do an advanced filter in Excel of our conflict list. There are 12 columns of data and approx 12,500 rows of data.

I am trying to do a custom filter where it will search across ALL rows and columns by a specific name (i.e., Jones). The end result I need is for a condense list that shows me any entry in the spreadsheet that has the text Jones or any name/word that contains Jones.

Right now I can only figure out how to filter on one column but I need to filter across ALL columns and rows.

This is a file I use every day and we spent a lot of time creating it.

Thank you!

[6StringJazzer]

Quickest way is to add column 13, put this formula in row 1 and fill down

Please Login or Register  to view this content.

Then autofilter on that column, to select all that are TRUE.