separate the last digits and sort and add the amount in each of the 4 patterns

**jorel** · 07-27-2021, 08:17 PM

separate the last digits and sort and add the amount in each of the 4 patterns
https://www.excelforum.com/attachmen...1&d=1627431411

**Rick Rothstein** · 07-27-2021, 08:50 PM

Put this formula in cell AG6...

=MOD(A6,10)

change the cell's format to "General" and then copy the formula across to cell BC6 (yes, I know it is copied across the cells for sums). Now, replace the formula in cell AL6 with this formula...

=SUM(AG6:AK6)

Now copy that cell and then paste it over the formula in cells AR6, AX6 and BD6. Now select the cells in range AG6:BD6 and copy it down to the end of your data.

separate the last digits and sort and add the amount in each of the 4 patterns

LinkBack

Thread Tools

Rate This Thread

Display

separate the last digits and sort and add the amount in each of the 4 patterns

Re: separate the last digits and sort and add the amount in each of the 4 patterns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] separate pairs without repetition of digits, that is 4 distinct digits .

[SOLVED] separate the last digits and add the amount in each group

separate last digits, and sort the 4 patterns and sums

[SOLVED] Please separate the first 4 last digits and rank in the 24 patterns.

[SOLVED] separate the start and end digits and high and low digits and *

[SOLVED] separate odd and even training in the 8 patterns

[SOLVED] Request, convert the 64 patterns to the digits from 000 to 999

Bookmarks

Bookmarks

Posting Permissions