Thanks for the reply.

I want it to show me how many times A1:AX1 contains the max value for each
column in the range A1:AX13.


"Ashish Mathur" wrote in message
...
Hi,

I am not sure if I understood your questions correctly but try this

COUNTIF(A1:AX1,MAX(A1:AX1))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Brian" wrote in message
...
Howdy All,

I have a table of values in 50 columns by 13 rows.

Each row represents Hours for an employee for each project list in the 50
columns

What I want to do is count the number of times each employee has the
highest hours.

So I want to count how many times the highest hours values occurs in each
row for the entire range.

I hope i'm making sense...

Thanks,
Brian