Wednesday, February 19, 2014

yogi_Find Names In Column A Associated With The Specified Number of Largest values In A Specified Column

                                         Google Spreadsheet   Post  #1538
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-19-2014
post by Bruno Augusto(https://productforums.google.com/forum/#!mydiscussions/docs/aHjfiylj9Y4)
Find values based on a filtered list of values
Good evening,


In A1:F6 I have a small "database".

The first row has a list of items which currently is finite, but I may need to add more in future. However these possible additions will not too much at once, though.

The first column holds a list of people names and following columns how much of each listed items they have.

In "Column H" I started testing how to filter the whole "database" to the ones matching the expression "Item #3".

But I'm having problems with next two steps, assuming they're possible:

1. Find the two largest values in this filtered list.

2. With these two entries, get the Name associated to them.

I hope the subject did not confuse you and I thank you in advance.
---