separate the last digit and classify the 6 patterns and add the amount
https://www.excelforum.com/attachmen...1&d=1660507546
separate the last digit and classify the 6 patterns and add the amount
https://www.excelforum.com/attachmen...1&d=1660507546
in Q6
=--RIGHT(A6,1)
copy across
in AG6
=COUNTIF($Q6:$AE6,AG$5)
copy across to AK5
in AL6
=SUM(AG6:AK6)
similar for others
Suppress zeros with format 0;0;;@
Last edited by JohnTopley; 08-15-2022 at 07:03 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Attachment 791679
And with ohn Topley's formulas, you get this distribution for the final SUM-column
(total size of the file = 1.3 MB = too large to publish)
Last edited by bsalv; 08-15-2022 at 01:02 PM.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
ok topley and bsalv, corret, conglatulations thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks