Hello,
Is there a way that i can filter out multiple numbers using auto filter?
We have an excel file with all of our stores and we need to filter out the warehouse locations but there's about 30 warehouses and this takes to long to filter in all the locations. Can I use the custom filter to bring up all of the warehouse locations in one click?
Thanks
Nate
Hi Nate - With 30 locations to assimulate data from, I'd suggest using the PIVOT function. It's not difficult to learn, as I nailed this down last month so that I do it consistently ... This link shares a simple approach you can experiment with, (as my example relates more to summarizing data, you can also create matrixes as well). This may not meet your needs, but wanted to share as an FYI ...
http://msmvps.com/blogs/harrywaldron...t-a-table.aspx
Here's another link on Pivot Tables and other bits and bobs
http://www.datapigtechnologies.com/ExcelMain.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks