Hi,
I have an excel sheet with 15 columns. I want to filter column B, it has over 100 cells for brand names.
For example,
Apple
Apple
Intel
Intel
Nike
Puma
Sony
I have a list of the brand names that I want to keep,
Sony
Intel
Apple
How would I use the filter in excel to filter the original list to only keep the brand names I want. I want it to work like a regular filter in excel where it hides the row of data that I want filtered out.
Thank you for your time.
To grab the subset at one go, one simple way is to use COUNTIF
Insert 2 new columns E and F, say
Paste your selected sublist items into F2:F4, ie
Sony
Intel
Apple
Put in E2: =COUNTIF($F$2:$F$4,B2)
Copy down, then filter on col E for 1
Copy the filtered rows and paste special as values into a new sheet
-----------------------------------
Any worth? Click the little star at the bottom left of my responses
When you start to filter, you can select/unsxelect multiple items, so all you need to do is just uncheck "ALL" and then check the items you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hi jimmy. 2 ways here to do Advanced Filter, if that's what you need.
1. set up a place to put your criteria. I can put in J1:J4
Brand
Sony
Intel
Apple
2. select your range to filter. say mine is in A1:G20. go to Data -> Advanced
3. List Range:
$A$1:$G$20
Criteria Range:
$J$1:$J$4
4. Press OK.
The other method is a slight change in Step 1 & 3.
1. Leave a blank cell in cell L1. then in L2 is a formula:
=OR($B2={"Sony","Intel","Apple"})
3. Criteria Range:
$L$1:$L$2
the other steps are the same
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Benishiryo,
Your sample excel sheet helped me understand how to do the steps more clearly. You've been very helpful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks