Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare last digit in 5 cells for match
I have 5 cells A1, A2, A3, A4 and A5. Each cell has a number in it. I would like to be able to compare the last digit of each cell for a 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 6 has a match and so does the 9. Not sure if this is possible. Any help is appreciated. Thanks
|
#2
|
|||
|
|||
Quote:
See the attached file hopefully this works for you, it uses the SUMPRODUCT function. Regards, Gizzmo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare cells and copy columns after match | Excel Worksheet Functions | |||
Compare several cells in row & output value for match | Excel Programming | |||
Can Formulas use a certain Digit, like the 1st or 2nd Digit, in all Cells in a Range? | Excel Programming | |||
Compare cells and concatenate on match | Excel Programming | |||
Open two worksheets, then match and compare cells | Excel Programming |