Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Question 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   Report Post  
Junior Member
 
Posts: 20
Default

Quote:
Originally Posted by Excelkid View Post
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
Hi ExcekKid,

See the attached file hopefully this works for you, it uses the SUMPRODUCT function.

Regards,

Gizzmo
Attached Files
File Type: zip ExcelBanter_Excelkid.zip (3.7 KB, 23 views)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare cells and copy columns after match Kcope8302 Excel Worksheet Functions 2 August 5th 09 05:37 PM
Compare several cells in row & output value for match Hannes Excel Programming 0 September 14th 08 03:29 PM
Can Formulas use a certain Digit, like the 1st or 2nd Digit, in all Cells in a Range? Arnold[_3_] Excel Programming 2 August 2nd 07 03:43 PM
Compare cells and concatenate on match [email protected] Excel Programming 2 January 18th 07 07:42 PM
Open two worksheets, then match and compare cells Bob[_15_] Excel Programming 0 August 8th 06 10:21 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"