E
Excelkid
I have 5 cells A1, A2, A3, A4 and A5. Each cell has a number in it.
would like to be able to compare the last digit of each cell for
match, and how many matches I have. The answer would go in cell A6
Example: 21,23,27,32,94=0 no match Example 2: 6, 9, 29, 66, 71 =2 the
has a match and so does the 9. Not sure if this is possible. Any help i
appreciated. Thank
would like to be able to compare the last digit of each cell for
match, and how many matches I have. The answer would go in cell A6
Example: 21,23,27,32,94=0 no match Example 2: 6, 9, 29, 66, 71 =2 the
has a match and so does the 9. Not sure if this is possible. Any help i
appreciated. Thank