Hello,
I need a formula that list the total number of each number combination found in column A in column E, which would correspond with the number values sorted in column C.
See the below for examples.
Column Formula Breakdown
A: contains number combinations
B: contains either win, loss, or break even.
C: contains the sorted combinations from column A
E: contains the total number of each combination found in column A and entered next to the sorted variation in column C
F: percentage of time the variation in column C appears amongst all variations
H: contains the total number of “wins” for each combination found in column A and entered next to the sorted variation in column C
I: percentage of time the “wins” of this number combination in column C appears amongst all variations
K: contains the total number of “losses/break evens” for each combination found in column A and entered next to the sorted variation in column C
L: percentage of time the “losses/break evens” of this number combination in column C appears amongst all variations
Please see spreadsheet for a better understanding.
Any and all help you could provide for any of the formulas would be greatly appreciated. Thank you.
Bookmarks