I am trying to get multiple headers to show such as (Mon-Sun) if the total amount being highest or lowest is the same.
What I am trying to achieve is that I need it to show Wens & Thurs or for the lowest Mon and Tues also if I could get the blanks to not calculate with the formulas. If cell is empty it still calculates which I need it to not calculate unless data is entered into the cell.
=INDEX($B$7:$B$15,MATCH(MAX(K7:K15),K7:K15,0))
=INDEX($B$7:$B$15,MATCH(MAX(K7:K15),K7:K15,0))
=INDEX($C$6:$I$6,0,MATCH(MIN($C19:$I19),$C19:$I19,0))
B C D E F G H I J K L
Beat Mon Tues Wens Thurs Fri Sat Sun Total Highest Lowest
W10 0 0 0
W20 1 10 13 13 1 3 3 44 13 1
W30 0 0 0
W40 0 0 0
W50 0 0 0
W60 0 0 0
W70 0 0 0
W80 0 0 0
W90 0 0 0
Highest Beat W20
Highest Day Wens
Lowest Day Mon
Thanks - J
Bookmarks