assumed data are in Col A : F

From range G1 to L4 put data like this

Day 7 8 9 10
Mon
Tue
Wed

in Cell H2 put this formula =MAX(IF($A$2:$A$10=$G2,B$2:B$10)) ( use
ctrl + shift + enter )

and drag it across and down.



On Dec 3, 12:26*am, SCC wrote:
Is there an equivilant of sumif for finding the maximum value. *Given the
data below I would like to find the peak value for each time of each day. *
The highest number for Monday at 7, 8, etc.

Day * * 7 AM * *8 * * * 9 * * * 10 * * *11
Mon * * 5 * * * 10 * * *23 * * *44 * * *35
Tue * * 1 * * * 9 * * * 18 * * *34 * * *60
Wed * * 9 * * * 25 * * *29 * * *48 * * *50
Mon * * 9 * * * 12 * * *14 * * *16 * * * * * *45
Tue * * 5 * * * 28 * * *30 * * *52 * * *55
Wed * * 9 * * * 25 * * *32 * * *62 * * *77