| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count number of values equal to MAX of a column
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
