Results 1 to 2 of 2
2005-09-10, 00:38 #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
2005-09-10, 03:26 #2
- 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.