Solved

Filtering on a list of data in Excel

Posted on 2015-02-06
3
143 Views
Last Modified: 2015-02-06
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
Comment
Question by:mte01
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 400 total points
ID: 40593712
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
 
LVL 4

Assisted Solution

by:scsyme
scsyme earned 100 total points
ID: 40593729
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
 
LVL 3

Author Comment

by:mte01
ID: 40593751
>>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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now