excel - How would I calculate the longest win streak and best/worst days of the week to play? -

i'm having trouble figuring out formula yellow fields highlighted in excel sheet. i'd calculate highlighted area:

1. best day of week play
2. worst day of week play
3. longest win streak

the below descibes how can 'carter', can change formula return values "pascal'.

1. best day of week play using index match on 'wins day of week' section, returning data in column h, selecting row based on max value i16:i22. you'll want consider value want returned if 2 days have same no. of wins. you'll need adjust ranges, demo'd on random cells on worksheet:

=index(b5:c9,match(max(c5:c9),c5:c9,0),1) 

2. worst day of week play best day, although select value based on min value in i16:i22. formula above change max min

3. longest win streak easier calculate if include streak column each player, , can use max value on entire column. in column increment cell above 1 if win player. if go down additional column route you'd need have formula such as:

=max(b:b) 

if column b had winning streak count, need have in cells formula in b2, looking winning name (pascal in instance, you'll need adjust cell reference column can't see image on edit page @ moment):

=if(d2="pascal",b1+1,0)