Find the strings of only the last digits of the numbers in the 5 sectors, please!

Find the strings of only the last digits of the numbers in the 5 sectors, please!
link=http://www.mediafire.com/file/eb42j93sg4n5s4c/pasta_string_hoje.xlsx

Ok, MIKE! you, have to sort as was in the example = have put the corresponding colors in the draws, my lottery is 100/20
You have each sector vector the strings, have the option to put new draws the macro go doing as it puts new draws of course
Can you put the planilia in a link, please?

Try this for starters:-
Your data starts "A3",Results start "W3".

Please Login or Register  to view this content.

Regards Mick

http://www.dec.org.uk/

Hello,MICK it's not like that, mick
You have to make each of the 5 colors, only last digit from 0 to 9 the strings
You have to see the strings for each of the 5 sectors. You have to mark the corresponding color in the draw list

Try this:-
NB:- The last Group of numbers has 99 instead of 89 and I've altered the the first "00" to 90
ONLY LAST DIGIT
1 2 3 4 5 6 7 8 9 0
81 82 83 84 85 86 87 88 99 00
91 92 93 94 95 96 97 98 99 00

Please Login or Register  to view this content.

Regards Mick

http://www.dec.org.uk/

Sorry the corret please is 89 90
99 00 error = is corret 89 90

Sub MG15Apr22()
Private Sub CommandButton2_Click()

error =Sub MG15Apr22()
Private Sub CommandButton2_Click()

Hello, MICK please can you put the code in the worksheet? When I try to activate, it shows error

error=Else
tmp = Application.Evaluate("=MATCH(" & Cells(i, ii).Value & ",4:4,0)")
Cells(i, tmp).Value = IIf(Cells(i, tmp).Value = "", "x", Cells(i, tmp).Value & ",x")
End If

excel 2014 Windows 7

YES,MIKE you have to make this correction in the sector,
Logically, 89.90 is correct! Sorry

Hello, mike de best, great, very good job, spectacular
It looks great.
Mike you did the 5 lines, now I'm going to link the 5 columns,
Is to do everything equal, just changed the sectors wait until I put the link
Use the same macro for the 5 columns or sectors

http://www.mediafire.com/file/v9115b...e_colunas.xlsx

Hello, mike is now only first digit only
Use the same formula or previous macro, so it changes
Now the scan is from the first digit ok.
Do the same, but with the first digit of the number
Option to go putting new draws of course

Originally Posted by jorel

Hello, mike is now only first digit only
Use the same formula or previous macro, so it changes
Now the scan is from the first digit ok.
Do the same, but with the first digit of the number
Option to go putting new draws of course

You should be able to do this, find in the code where it has Right(.....,1) change to Left(.....,1)

But changed the letters in the new worksheet, changed the reference, is the colors? please

error=or ii = LBound(sCols) To UBound(sCols)
Cells(i, sCols(ii)).Value = BubbleSrt(sMyStrings(ii), True)

Function not defined compilation error

Mike can not ride, hiker does not have much talent in excel
I will not be able to ride for years.

Try your returned file:-
See sheet2.
Check results that are showing, then remove and run code again to test.

http://www.mediafire.com/file/v9115b...e_colunas.xlsx

But it's another spreadsheet with groups for the columns! Another planilia with the same conditions only changed the groups

new link=http://www.mediafire.com/file/s25p175day697kq/string%2Cnova_planilia__columm.xlsx

k? Color of cell is self adjusting

new link=http://www.mediafire.com/file/s25p175day697kq/string%2Cnova_planilia__columm.xlsx

OK man! Mike, great job congratulations, works perfect,
Mike, you're great at excel, congratulations, thank you,