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!
Last edited by shg; 07-23-2011 at 12:12 PM. Reason: Restore original post.
Quickest way is to add column 13, put this formula in row 1 and fill down
Then autofilter on that column, to select all that are TRUE.=NOT(ISERROR(FIND("Jones",CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,I1,J1,K1,L1))))
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks