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