• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

Filtering on a list of data in Excel

Hey experts,

I have an excel file (ms excel 2007) with 8 fields and around 4000 records.
I want to do a filter on one of those fields (username) to be equal to any of around 200 given values.

Any idea on how this can be done?
0
mte01
Asked:
mte01
2 Solutions
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
You can use a helper column and use a COUNTIF formula for that column.

See the attached - it's easier to show you than to explain.
EE150206.xlsx
0
 
scsymeCommented:
Not sure what flexibility you have to make additions to the workbook / data. I would suggest making a table of the values to be matched and then adding an extra column to implement a vlookup formula. Something like the below, assuming your field is in column F and your new table is called tblMatchValues.

=IFERROR(VLOOKUP(F2, tblMatchValues,1,FALSE)=F2,FALSE)

Open in new window


Then filter on the new column where value = TRUE
0
 
mte01Author Commented:
>>Phillip Burton

Works very well - don't know why I didn't think of this method although am frequent user of excel.
And I did it by the way without looking at your template (which is better I guess).

Many thx again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now