Ok, so I'm using excel to figure out a Best Day in which I'm trying to figure out how to take two different sets of data for the same day, number of wins and losses for the day. I want it to work as follows: Take Monday's wins and subtract it's losses from it, then do the same for each other day, then take the highest number here and return the name of the day, not the number it calculates. I'm kind of lost on how to do this exactly.
An attachment of the actual worksheet I'm working on is included.web attachment.xlsx
Bookmarks