| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Max values in a range
Lars is correct. Thank you.
"Lars-Åke Aspelin" wrote in message ... On Sat, 20 Sep 2008 12:26:35 +0530, "Ashish Mathur" wrote: Hi, Try this. COUNTIF(A1:AX1,MAX(A1:AX13)) MAX(A1:AX13) returns the "global" maximum. I think what the OP wants is to compare, per project/column, each employees hours to the maximum hours for that project, not to the "global" maxiumum. Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count values in a range of cells | Excel Worksheet Functions | |||
| count even-numbered values in a range | Excel Discussion (Misc queries) | |||
| How do I count unique values within a date range? | Excel Discussion (Misc queries) | |||
| how do i count cells with values in a certain range ? | Excel Discussion (Misc queries) | |||
| Count the how many different values in a range | Excel Worksheet Functions | |||
Hybrid Mode
