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
|