View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Count Max values in a range

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