Solution to Return top 5 values based on a criterion

Solution for: http://excelexperts.com/return-top-5-values-based-criterion
In brief: you need Category List re-arranged, additional column in "Average Rank" sheet and named ranges for newly inserted column and all months respectively.
In detail: I re-arranged Category List and made a new one on sheet "Category_New".
Then I inserted a column on sheet "Average Rank" containing type (Composite, Standalone etc.).
Named ranges were created for march and april 2013 (containing values).
Finally, array formula calculates Top 5. Example for February 2013 - "Composite":
=LARGE(IF(Typess=$P$4;febr2013;"");1)
It returns the first largest value in column of February 2013 where "Type" is "Composite".
Type is in B column on sheet "Average Rank", and "Febr2013" is a column containing values for February 2013. $P$4 is a fixed cell value ("Composite") on sheet "Average Rank".
Attachment | Size |
---|---|
Top sports apps.xlsx | 255.12 KB |
- Almir's blog
- Login or register to post comments
- 4717 reads
Recent comments
6 years 3 weeks ago
6 years 41 weeks ago
7 years 1 week ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 10 weeks ago
7 years 18 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago