Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

SELECT DATA 4N tri and double digit

selcect the 3 digit and company and be show as here

c1.PNG
also the doubl digit pair

as show
b2.PNG4N_tri.xlsm
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Try this.
29167322.xlsm
ADRIANA P

ASKER
MArtin

is not working
ADRIANA P

ASKER
d1.PNG
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss

This should be better.
29167322a.xlsm
ADRIANA P

ASKER
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é.
2019-12-17_08-21-32.png
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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.

2019-12-17_08-21-32--1-.png
ADRIANA P

ASKER
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
ADRIANA P

ASKER
The DOUBLE DIGIT

you did is GOOD

example  3377     should be as  33  77     as you did
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
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.
ADRIANA P

ASKER
Martin
e1.PNG

like this
ADRIANA P

ASKER
but this is not good

f1.PNG
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
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'?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
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.
ADRIANA P

ASKER
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great Job !

Best Expert !