top 3

I am measuring "population" for states/cities. I would like to get a list of top 3 states/cities in critical status based on population. The dataset I am using has metrics for years 1910-2017. Short example with made up data: A B C D E 1 State City Year Status Population 2 Pennsylvania...

Hi all, I am creating a report template and I am having issues with one formula. I have 2 sheets, one has the report, one has the data - this one is called FB_POST On the data sheet, column B cells will say either "This week", "Last week" or be blank. On the report sheet I want a formula...

I have a pivot table containing 80 column labels and 4000 rows of data values. what i need is a formula to find the top 3 values but to return the column labels and not the values themselves. I've used the following to return the highest values corresponding column label but i'm not sure if...

For example, a product table has thousands of product numbers in the rows, but the unique product code distinguishes certain categories of the items by the third letter being A for Antennas, B for Brackets, C for Cones, and so on for dozens more, with numerous sizes and models available in each...

Hi All, Firstly, apologies if this is posted elsewhere, I tried searching for a similar issue but couldn't find any similar threads. The Situation/Project I've been working on a project that allows a member of staff to lookup a information on a client based on our unique ID for them, this...

I have a report in Excel with month filter based on my powerpivot data model. I'd like to show 3 latest months on my report all the time. - When user filters report with month 112015, I'd like to show months 112015, 102015 and 092015 - When user filters report with month 022015, I'd like to show...

Example Dataset: A B 1 Name1 10 2 Name2 20 3 Name3 50 4 Name4 40 5 Name5 40 Using the combination of INDEX, MATCH and LARGE, I used to be able to get the the names (colA) of the Top 3 results, this only works if there are unqiue values...