About
Pricing
Community
Teams
Start Free Trial
Log in
ADRIANA P
asked on
12/16/2019
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
VBA
Microsoft Excel
Microsoft Office
20
1
Last Comment
ADRIANA P
8/22/2022 - Mon
Martin Liss
12/16/2019
Try this.
29167322.xlsm
ADRIANA P
12/16/2019
ASKER
MArtin
is not working
ADRIANA P
12/16/2019
ASKER
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss
12/16/2019
This should be better.
29167322a.xlsm
ADRIANA P
12/17/2019
ASKER
Best expert the tri digit
shoul be like 2229 222 then 9
Martin Liss
12/17/2019
That's not what your example shows, but I'll change it.
Eso no es lo que muestra su ejemplo, pero lo cambiaré.
⚡ 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
12/17/2019
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.
ADRIANA P
12/17/2019
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
12/17/2019
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
12/17/2019
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
12/17/2019
ASKER
Martin
like this
ADRIANA P
12/17/2019
ASKER
but this is not good
⚡ 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
12/17/2019
ASKER
should be
555 then 7
Martin Liss
12/17/2019
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
12/17/2019
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
12/17/2019
ASKER
Martin
the TRI Digit not always are the first three
Martin Liss
12/17/2019
If it is "not always are the first three" then please tell me what it is.
ADRIANA P
12/17/2019
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
12/17/2019
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
12/17/2019
ASKER
Great Job !
Best Expert !