Count number of values equal to MAX of a column

  • Thread starter Thread starter dauclair
  • Start date Start date
D

dauclair

I'm trying to find the number of values in a column that equal th
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find max with a lookup 2
Excel Help to copy information from one row at a time to another sheet 1
Duplicate max values in one cell required 2
Excel Need Countifs Formula Help 0
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Index, Match within a range of values 4
insert row when sum of values equals 100 3
Multiple conditions 2

Back
Top