Hi excel gurus,
I am working on a big data file relating to exam results. approximately 50000 rows. I want a drop down menu or any other excel option to summarize the data into location wise. Attach excel sheet column B consists of location. I need a option in the same sheet when I click UK all data need to appear. When I sent this data location rep like to see there data only. Pivot table I tried. Please help me on this.
Bookmarks