# SELECT DATA 4N tri and double digit

selcect the 3 digit and company and be show as here

also the doubl digit pair

as show
4N_tri.xlsm
VBAMicrosoft ExcelMicrosoft Office

Last Comment

8/22/2022 - Mon
Martin Liss

Try this.
29167322.xlsm

MArtin

is not working

Martin Liss

This should be better.
29167322a.xlsm

Best expert the tri digit

shoul be like 2229     222   then 9
Martin Liss

That's not what your example shows, but I'll change it.

Eso no es lo que muestra su ejemplo, pero lo cambiaré.
Martin Liss

It doesn't agree with your headings either so please make sure that you want me to change it.

Tampoco está de acuerdo con sus títulos, así que asegúrese de que desea que lo cambie.

Martin

yes can be change

when i say TRI  i mean the digit three times the same

0777   is  777 the tri  then the 0 the company

The DOUBLE DIGIT

you did is GOOD

example  3377     should be as  33  77     as you did
Martin Liss

I'm confused. Please show me what the headings should look like and what row 46 should look like.

Estoy confundido. Por favor, muéstrame cómo deberían verse los encabezados y cómo debería verse la fila 46.

Martin

like this

but this is not good

should be

555  then 7
Martin Liss

Please tell me in words, what goes in column 'H'? Is it always the last three numbers from column 'F'?

Por favor dime en palabras, ¿qué pasa en la columna 'H'? ¿Son siempre los últimos tres números de la columna 'F'?
Martin Liss

should be

555  then 7
So is it always the first 3 numbers from column 'F'?

Entonces, ¿son siempre los primeros 3 números de la columna 'F'?

Martin

the TRI Digit not always are the first three
Martin Liss

If it is "not always are the first three" then please tell me what it is.

TRi

are the three  same  digit

but can be any position  5557       555  are  the  three digit  then 7

4666   4 then 666 are the three digit