View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Michael

You can use this to get the value

=MAX(A1:A20)

and this to count

=COUNTIF(A1:A20,MAX(A1:A20))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael via OfficeKB.com" wrote in message ...
I have a lot of spreadsheets with many rows and columns of numbers. I need
a way to find the highest value in each row, (mark it some how, bold the
number maybe), then count the number of "highest" values are in each
column.

Is there an easy way to do this?

Thank You,
Michael