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
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,
Demo Spreadsheet (not that is needed...): https://docs.google.com/ spreadsheets/d/ 1PpNKQn5aYBik1jLHHU5FWoMX2uhAW APdqezkxmjYKik/edit#gid=0
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.
---
No comments:
Post a Comment