?
Solved

Filtering on a list of data in Excel

Posted on 2015-02-06
3
Medium Priority
?
156 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 1600 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 400 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

801 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