Hi,
Well I have tried and tried. Hope you can help.
I have a column of numbers in "G" Say it starts at G2 and goes to G100 (See Below)
The numbers have a comma between but not leading or trailing, they are all in 1 cell.
I know if I take them out of a single sell I can do but the Qty of numbers changes and I would like to try to solve as is.
2,7,9,11,13,15
3,8,9,12,13,15
4,7,10,11,14,15
5,8,10,12,14,15
6,9,10,13,14,15
1,2,3,16,17,18
1,4,5,16,17,19
2,4,6,16,18,19
3,5,6,17,18,19
1,7,8,16,17,20
2,7,9,16,18,20
3,8,9,17,18,20
4,7,10,16,19,20
5,8,10,17,19,20
I want to have a reference cell that counts the times a number appears in that column G
EG Number 1 3
Number 2 4
So I need a formula that can do this.
Much appreciated
David