separate the last digit from each draw line and add up to each * digit

**jorel** · 03-17-2019, 02:22 PM

separate the last digit from each draw line and add up to each
* digit =
* so you will separate the last digit
* example
17 (7) is the last digit, then add the quantity
* of each digit in the draw line we have 0 to 9 digits
https://www.excelforum.com/attachmen...1&d=1552846934

**MarvinP** · 03-17-2019, 03:25 PM

Hi jorel,

Easy Peasy with Mod 10 and a countif. See the attached.
Mod 10 then Countif.xlsx

**jorel** · 03-17-2019, 05:28 PM

hello, MARVINP. Great job, congratulations, thank you!

separate the last digit from each draw line and add up to each * digit

LinkBack

Thread Tools

Rate This Thread

Display

separate the last digit from each draw line and add up to each * digit

Re: separate the last digit from each draw line and add up to each * digit

Re: separate the last digit from each draw line and add up to each * digit

Thread Information

Users Browsing this Thread

Similar Threads

Color a single digit in a mult-digit number cell

Mexcel-2010, 16 digit number's last digit changes to zero, format cell doesn't help

Bank Recon - How to convert 8 digit formatted check numbers to 6 digit

Formula to automatically increase 4 digit suffix if 4 digit prefix is same as another

Create a 3 digit alphanumeric series in a sequential order but the first digit must be 1

[SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash

Entering 5 digit number, where each digit creates a specific result based on a list.

Bookmarks

Bookmarks

Posting Permissions