Solved: SELECT DATA 4N tri and double digit

Create Account

Microsoft Excel

Questions

Followers

Top Experts

ADRIANA P🇺🇸

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

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Martin Liss🇺🇸

Try this.
29167322.xlsm

ADRIANA P🇺🇸

ASKER

MArtin

is not working

ADRIANA P🇺🇸

ASKER

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

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é.

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

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.

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

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

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

like this

ADRIANA P🇺🇸

ASKER

but this is not good

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

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'?

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

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

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTION

Martin Liss🇺🇸

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

ADRIANA P🇺🇸

ASKER

Great Job !

Best Expert !

Microsoft Excel

Questions

Followers

Top Experts

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.