I would like to select about 1000 users in a pivot table with over 100,000. I am using Excel 2013 on a MAC. Any advice on the easiest way to do this greatly appreciated.
I would like to select about 1000 users in a pivot table with over 100,000. I am using Excel 2013 on a MAC. Any advice on the easiest way to do this greatly appreciated.
You could use quick and easy logic in a helper column in the raw data, then just filter on that helper column.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
How are you selecting the names?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks