Winalot2007
Member
I have the following values in cell range A1 through C1
A1 = 9
B1 = 0
C1 = 4
In cell range A2 through C2 are the following values:
A2 = 0
B2 = 0
C2 = 7
The answer should be 1 since only the 0 from B1 appears in A2 and B2
If the digits were 0 0 4 in cell range A1 through C1 then the answer would be 2 since ther are 2 zeroes in each of the cell ranges.
Thanks in advance!!
A1 = 9
B1 = 0
C1 = 4
In cell range A2 through C2 are the following values:
A2 = 0
B2 = 0
C2 = 7
The answer should be 1 since only the 0 from B1 appears in A2 and B2
If the digits were 0 0 4 in cell range A1 through C1 then the answer would be 2 since ther are 2 zeroes in each of the cell ranges.
Thanks in advance!!