Google Spreadsheet Post #1682
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-27-2014
post by Stefan Kubler Palfner: ( Google Spreadsheet Post #1681
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-27-2014
post by Stefan Krause Palfner: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/KR2jFgOY6uY)
Need Help: COUNT quantity of highest values in a row
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-27-2014
post by Stefan Kubler Palfner: ( Google Spreadsheet Post #1681
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-27-2014
post by Stefan Krause Palfner: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/KR2jFgOY6uY)
Need Help: COUNT quantity of highest values in a row
Hey, I have the following table:
A | B | C | D | |
1 | 28.00 | 8.00 | 48.00 | 36.00 |
2 | 28.00 | 24.00 | 32.00 | 36.00 |
3 | 25.00 | 9.00 | 52.00 | 32.00 |
4 | 27.00 | 27.00 | 18.00 | 28.00 |
5 | 44.00 | 32.00 | 16.00 | 28.00 |
6 | 44.00 | 12.00 | 44.00 | 20.00 |
7 | 16.00 | 36.00 | 28.00 | 40.00 |
8 | 48.00 | 12.00 | 32.00 | 28.00 |
9 | 36.00 | 32.00 | 8.00 | 44.00 |
10 | 36.00 | 40.00 | 24.00 | 20.00 |
I want to count the number of values of a column, where this value is the highest number in that row. I marked the high numbers bold. So for A the count = 3, for B = 1, for C = 3 and for D = 4. I tried using COUNTIF, but cannot seem to find the correct formula. I want to display the count below in a new row. Which is the correct formula to COUNTIF, this value =MAX in the respective row?
-------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment