I would like to program 3 tables within excel that automatically updates the following data:
in U column
how many 3s, 2s 1s, and 0s in the last 10 entries and the percentages for each.
Also, how many for the last 100 entries and their percentages.
I have a 2nd column (column EM) that produces 0s, 1s, 2s and 3s. I need the last 10 entries and the percentages for each.
Also, how many for the last 100 entries and their percentages.
I would like to do the same for the data in a 3rd column (AV column) which has only 1s, 2s and 3s.
Some cells in the columns are blank, so ingnore those as non-entries.
in U column
how many 3s, 2s 1s, and 0s in the last 10 entries and the percentages for each.
Also, how many for the last 100 entries and their percentages.
I have a 2nd column (column EM) that produces 0s, 1s, 2s and 3s. I need the last 10 entries and the percentages for each.
Also, how many for the last 100 entries and their percentages.
I would like to do the same for the data in a 3rd column (AV column) which has only 1s, 2s and 3s.
Some cells in the columns are blank, so ingnore those as non-entries.
PC Pick3 System Chart3.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
EC | ED | EE | EF | EG | EH | EI | EJ | EK | EL | |||
21 | E/O(ColumnU) | D/S(ColumnAV) | ||||||||||
22 | 3 | 2 | 1 | 0 | 1 | 2 | 3 | |||||
23 | Last10 | Last10 | ||||||||||
24 | % | % | ||||||||||
25 | Last100 | Last100 | ||||||||||
26 | % | % | ||||||||||
27 | ||||||||||||
28 | ||||||||||||
29 | H/Low(ColumnEM) | |||||||||||
30 | 3 | 2 | 1 | 0 | ||||||||
31 | Last10 | |||||||||||
32 | % | |||||||||||
33 | Last100 | |||||||||||
34 | % | |||||||||||
combo |