Solved

Filtering on a list of data in Excel

Posted on 2015-02-06
3
144 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

13 Experts available now in Live!

Get 1:1 Help Now