Results 1 to 2 of 2

Excel conflict list sorting

Threaded View

amadtaz Excel conflict list sorting 07-22-2011, 11:13 AM
6StringJazzer Re: Excel conflict list... 07-22-2011, 04:43 PM
  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    San Francisco
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    1

    Excel conflict list sorting

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1