View Single Post
  #4   Report Post  
Michael via OfficeKB.com
 
Posts: n/a
Default

How can I count how many of the highest values are in each column. Example:
Rows = Hours, Columns = Days. I need to find out which of the hours in each
day is the highests number. Next I need to count how many days have the
same hour as its highest number.

1:00 2:00 3:00 4:00
Monday 12 13 14 15
Tuesday 16 18 25 10
Wednes. 20 14 40 30

Total: 1 1 2 0 <- this is the output im looking for