Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-25-2022, 07:19 PM
Karen615 Karen615 is offline Sum Unique Digits Windows 7 64bit Sum Unique Digits Office 2010 64bit
Competent Performer
Sum Unique Digits
 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default Sum Unique Digits

I have a long list of numbers that have five unique digits at the beginning of the number that signifies a specific product. What is the best way to sum up these products as I have indicated below? Your help is greatly appreciated. I'm using Excel 365.

12345678
12345876
01234565
01234575
23456780
23456874


23456235

12345 = 2
01234 = 2
23456 = 3

Thank you,
Karen
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Unique Digits Find last three digits after . ( including zero) LearnerExcel Excel 4 02-08-2018 10:49 AM
Entering a number of 19 digits Jo Freeman Excel 11 11-08-2017 06:20 AM
Having number's digits together mohsen.amiri Word 0 06-23-2017 01:20 AM
Sum Unique Digits Need help calculating frequency of digits laucn Excel 2 06-08-2015 07:50 AM
Sum Unique Digits Problems merging in last 4 digits of an account higher than 16 digits Glynda Mail Merge 1 04-08-2011 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft