Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Thanked 0 Times in 0 Posts

    Auto Filter Same info multiple columns (Excel 2002)

    I have a sheet that has multiple columns. One column lists a 'Lead person' and another lists a 'Secondary person'. For example, Joe Smith could be listed as a lead for one site and a secondary on another. I want to be able to see all the sites that Joe Smith is assigned to.

    I set AutoFilters and select the filter for 'Lead Person' column for Joe Smith. I get Joe Smith. I want to filter the 'Secondary person now however I cannot get the filter to work on the secondary column at the same time to filter for Joe Smith. Does anyone have a suggestion on how I might achieve this? Thanks for the help

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Auto Filter Same info multiple columns (Excel 2002)

    You could add a new column which concatenates the 2 columns (eq A2&B2) then filter for this column containing the name of interest.

    Or you could make a combobox with the list of names to select (separate from the table). Have the selection in cell F1 (eg) then use something like this in a new column:
    Then filter this column for TRUE.


Posting Permissions

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