Friday, June 27, 2014

yogi_Count Column By Column (from A to D) Number Of Rows That House The maximum Value in that Row

                                         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
Hey, I have the following table:

ABCD
128.008.0048.0036.00
228.0024.0032.0036.00
325.009.0052.0032.00
427.0027.0018.0028.00
544.0032.0016.0028.00
644.0012.0044.0020.00
716.0036.0028.0040.00
848.0012.0032.0028.00
936.0032.008.0044.00
1036.0040.0024.0020.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