Forum Discussion
Solved
Working out Win/Loss Percentage
I want the cell V12 to be able to calculate Win% (based on the result in H Column) of specific Unit vs Unit matchups so for example how often does FCC in the B:F Column Win against Charlotte appearing in the J:N Column. I have been stuck all day trying to make it work
See attached spreadsheet.
2 Replies
See attached spreadsheet.
Wow that worked great. I wanna try and see if it can run for when 2 heroes are on the My Unit side and 1 is on the Enemy unit side to see how often i win with a combo. Would i need to just change where it has V8 to V8:W8?
