Tuesday, November 20, 2012

yogi_Extract Top N Values Based On Specified Value Of N Specified Column And Specified Order

                                          Google Spreadsheet   Post  #876
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 20, 2012
user Edd Smith said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/lDcd_E8Hqgk)
I have a list of Risks which have descriptions in A,B and Score in C. The score can be anything from 0 to 25.
The list contains 30 elements.
On a seperate worksheet I want to to auto magically check the dataset above and only show me the top ten. I can rank them using the rank command, but not sure how to show the results.
---
I have added sample data and what I should get
Attachments (1)


Book3.xlsx
14 KB   View   Download
 --------------------------------------------------------------------------------
following is a solution to a bit more generalized problrm