I have this kind of comma separated numbers in "Original file", column A (in cells - A1, A2, A3)
4,5,7,8,9,16,17,18,19,20,21,22
4,5,6,7,8,9,16,17,18,19,20,22,23,24
4,5,6,7,8,9,16,17,18,19,20,21
I need to calculate how many unique numbers in those cells,
such as...
1-0
2-0
3-0
4-3
5-3
6-2
.
.
.
.
21-2
22-2
23-1
24-1 and so on.
I find it with the value which locate in cell B1.
I try this formula - {=COUNT(FIND(B1,'Original File'!$A$1:$A$3))}
but it counts all 1s and 2s which is in 12,21,22 and all other numbers also.
please help me.. thanks
Bookmarks