I have a file containing over 50 investment analytics, and several calculated analytics using these 50 given analytics, for different styles of over 500 mutual funds. I've created a Pivot Table which allows me to filter each style and I've arranged the columns in the Pivot table to show only the data I'm most interested in viewing. Although I can sort each column of data to look at how well each fund does on a single criteria, I'm looking for a way to define multiple criteria I'm looking for and only find those finds that meet those multiple criteria.
How would I accomplish this?
Thanks in advance.
Randy in Florida
Bookmarks