Ok so I want to count Ones, Twos and so on in column A. In Column C is just 1 thru 11. Column D is the output. Now I filled in column D by just counting how many ones and twos and so on. I hope I have the right amount in column D. Column A will have the dashes and could have no less than 3 numbers but no more than 5 numbers. I can go with a formula or VBA.
Thanks in advance
Thanks in advance
Rank 1.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 6-1-9 | 1 | 3 | |||
2 | 11-2-4 | 2 | 3 | |||
3 | 10-9-11-1-2 | 3 | ||||
4 | 10-9-11 | 4 | 1 | |||
5 | 2-11-9-1 | 5 | ||||
6 | 6 | 1 | ||||
7 | 7 | |||||
8 | 8 | |||||
9 | 9 | 4 | ||||
10 | 10 | 2 | ||||
11 | 11 | 4 | ||||
Rank |