Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • 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 BurtonCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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