Count Max values in a range
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
|