detect code 6,7,8,9. well we have 8 possible numbers .

[jorel]

detect code 6,7,8,9.
well we have 8 possible numbers
in last digit code,
* 06 07 08 09 16 17 18 19
the macro will detect on last digit
6,7,8,9 in their respective positions
* of the sweepstakes, this code 6,7,8,9 is last
* number digit
* example 17 last digit is 7
https://www.excelforum.com/attachmen...1&d=1564427055

[José Augusto]

Hi

Try this formula in Q5 and drag down and forward.

Please Login or Register  to view this content.

[jorel]

hello,AUGUSTO= THANK YOU
the formula has to be in portuguese
* excel 2016

[AliGW]

Formula translator: https://en.excel-translator.de/translator/

[Marc L]

As any english formula can be directly added to a cell whatever the Excel local version
on VBE side via the Immediate window (Ctrl G) …

[José Augusto]

Hi

Formula in Portuguese, Portugal
=SE(É.NÚM(LOCALIZAR(DIREITA(A5;1);"6789"));A5;"")

Formula in Portuguese, Brazil
=SE(ÉNÚM(PROCURAR(DIREITA(A5;1);"6789"));A5;"")

Nota: Como pode ver, existem pequenas diferenças entre as duas fórmulas, nada que o tradutor não o possa fazer (Thanks to @AliGW for the link).

[jorel]

hello,AUGUSTO, perfect, conglatulations, thank you!!
funcionou !abraçoes