win/loss

This code displays my Win/Loss Percentage. I'm using an auto-filter macro to filter data and I would like to show my Win/Loss percentage on visible rows only. Can someone assist. Thank you kindly. With WorksheetFunction CCI = Format(.CountIf(Range("P18:P" & LRow), ">" &...

I want to calculate the WIN/LOSS percentage from columns H4 to H20. All numbers below 0 would be considered a loss and all numbers above zero a win, and the result = %. Just an example of four numbers H4=10,H5=100,H6=-30,H8=-10 than WIN/LOSS is two wins and two losses resulting in 50%. The...

Hi Everyone, I'm trying to automate some statistics for my softball league, and one of the things I want to look at is opponent's Win-Loss record. I want to solve the problem using array formulas, but I can't seem to crack it. We have a table of home team/away team and another table of...

<tbody> a b c d e 1 #of trades total trades made won lost won/lost running percentage 2 1 1 1 0 3 1 2 1 0 4 2 4 1 1 5 1 5 0 1 6 2 7 2 0 7 0 7 0 0 8 1 8 1 0 </tbody> Thank you for your help first off. I am a day trader and I am trying to get my log together...

Hi Everyone, I'm hoping that someone might be able to help me or at least make my life easier. I run a fantasy football competition and at the end of each year I update a table that show's the head-to-head record of the teams in the league (Website link: http://goo.gl/3Jec5). The only way I...