separate last digits, and sort the 4 patterns and sums

[jorel]

hello please=separate last digits, and sort the 4 patterns and sums
https://www.excelforum.com/attachmen...1&d=1541261833

[jorel]

hello.remembering, I'll put number draws

[MrShorty]

How much of the sample is required, and how much can be changed. Here's how I would probably do this (without the "x" characters):

1) Use the MOD() function to get the units digit from each number. J5=MOD(A5,10) copied and across.
2) Use a COUNTIFS() function to get how many odd, even, high, low are in J5:P5 (instead of x characters). S5 =COUNTIFS($J5:$P5,S$3) [note the mix of relative and absolute references] for easy copying. Copy across to W5.
3) A simple SUM() function to get the sum of each group X5=SUM(S5:W5)
4) Select S5:X5 -> copy -> select Z5:AE5 and paste -> Selct AG5:AL5 and paste and so on going across.
5) It looks like you want AS5 to be formatted as "00" rather than general.
6) Select J5:AS5 -> copy and paste down as far as needed.

That seems to work in your sample, and the only difference is I am not using the x characters. Are the x characters essential?

[jorel]

hello mr shorty, thank you for viewing the post, the x characters are not needed, can you get by on planilia? please

[AliGW]

Jorel - Mr Shorty has given you very, very clear instructions. You always want your helpers to do it all for you - really, it's time now you started to make more of an effort to help yourself. Follow the instructions - you might actually learn something!

[MrShorty]

It will be some time before I will be in a position to upload an actual Excel file. Like AliGW suggested, I was hoping that my instructions were clear enough for you to enter the formulas yourself. Is there a step or formula that you are having trouble entering?

[kvsrinivasamurthy]

Does all the steps shown in the file are required or only the sums of odd and even numbers for each row.