detect in the front pair in each group of the corresponding 7 and its frequency

[piter]

please detect the front double of the pick3 and see the amount of each groups.
Step 1, put the pickings of the pick3 in ascending order
Step 2 separate the front pair.
3º detect in the frontal pair in which of the 7 groups
4º to see the frequency (quantity of each group)
http://www.mediafire.com/file/oohp3btusm7q7hz/ordem_crescente_%25283%2529_%25281%2529.xlsx/file

 

[Fluff]

Cross posted

Once again you have decided to ignore our rules.
Please supply the link

 

[piter]

link=[h=2]please detect the front double of the pick3 and see the amount of each groups.[/h]

 

[Fluff]

There is no link in that post, it's just text

 

[piter]

https://www.excelforum.com/excel-pr...-pick3-and-see-the-amount-of-each-groups.html