Thread
:
Count number of values equal to MAX of a column
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Count number of values equal to MAX of a column
=COUNTIF(B3:B723,MAX(B3:B723))
HTH
--
AP
"dauclair" a écrit
dans le message de news:
...
I'm trying to find the number of values in a column that equal the
maximum value of that column.
If it didn't return a -0-, this is what I would like to do:
=COUNTIF(B3:B723, "=MAX(B3:B723)")
If the column contained: (1, 2, 3, 4, 5, 5, 5, 2),
I would like (3) returned.
--
dauclair
------------------------------------------------------------------------
dauclair's Profile:
http://www.excelforum.com/member.php...o&userid=34852
View this thread:
http://www.excelforum.com/showthread...hreadid=546688
Reply With Quote