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