detect the 4 patterns * after separating the last digit

detect the 4 patterns
* after separating the last digit

https://www.excelforum.com/attachmen...1&d=1558422247

I think you need to offer some explanation, as i have no idea what you want to achieve

ok, davsth, the macro has to separate the last digit, then identify (x) or another signal,
the corresponding digits,
* The goal is to identify 4 patterns
* the presence of each digit

This is a guess, but I think I know what you're getting at...

Did you specifically want a Macro to do this or would Formulas be ok?

I've attached what I *think* you're after using Formulas, if you do want a Macro solution then post back.

ok, PAULSP8, this is correct, perfect, congratulations,
PAULSP8, a question = in the 4 patterns, generated
in the white space columns and
* repetitions, do you know in any way
Do you foresee the seqeuncias, empty and the floods by column?

Sorry, I do not understand what you mean - Can you post another example and I will see if I can work it out from there?

what, your macro is correct,
it generated by column, empty spaces and full seqeuncias, how to take advantage of this by column?

I am sorry, I still do not understand.

I do not know what you mean by "take advantage of this by column" - How do you want to take advantage of it?

the macro generate pattern sequences by columns, how to take advantage of this?

Like this?

If not then could you please post an example of what you mean by "take advantage of this" as I can not understand what you mean.

I will not be able to help further unless you can explain what it is you need.

Okay, thank you for seeing, I'm already good.