Find location 4N TOPWK

You forgot set R

Thanks Karen Falandays

Where will you enter new data? Rows 6 to 3, or column 'D' rows 28 to 39, or both?

both

Will the SETS portion always contain just one week's data?

Yes!

Then why do you have SETS M through S?

Then why do you have SETS M through S?

Sometimes it grew more than usual

If that's true then don't you need more rows after row 39?

No.

Row F13  to F17 works with the DD numbers
i don't know how many DD numbers will Show by week

it can ALL week sometimes

example
of DD number is 2611

Can I remove column C?

yes

I understand the uppercase and lowercase letters, but in the results you show for the number 4615 I need you to explain how the first three results (uAB, vIuA, and xE) are calculated.

Entiendo las letras mayúsculas y minúsculas, pero en los resultados que muestra para el número 4615 necesito que explique cómo se calculan los primeros tres resultados (uAB, vIuA y xE).

uAB  = 15

xE = 48

i mean this 48 is 4689


don't do vIuA  
because it cross column
just stay in the column

I'm asking you to explain results for 4615, not 4689.

4615,    have 15   thats uAB  = 15

(uAB, vIuA y xE)

Sorry ! but what you means ?

This is a mystery to me. Let's look at the results for 4689.

First result: Is it blank because the both of the last two characters (89) are not in the U column?
Second result: Is it vEuD because the first 3 characters (6, 4 and 8) match "648" under "X"?
Third result: Is it xE because the first and third characters (4 and 8) match "48" under "Y"?
Fourth result: Is it zC because the first and third characters (4 and 8) match "48" under "Z"?
Fifth result: I have no idea why it is aBACI

Primer resultado: ¿Está en blanco porque los dos últimos dos caracteres (89) no están en la columna U?
Segundo resultado: ¿Es vEuD porque los primeros 3 caracteres (6, 4 y 8) coinciden con "648" debajo de "X"?
Tercer resultado: ¿Es xE porque el primer y tercer caracteres (4 y 8) coinciden con "48" debajo de "Y"?
Cuarto resultado: ¿Es zC porque el primer y tercer caracteres (4 y 8) coinciden con "48" debajo de "Z"?
Quinto resultado: no tengo idea de por qué es aBACI

ok i will work this questions

but will need an chance to

First result: Is it blank because the both of the last two characters (89) are not in the U column?
 in this case the only digit is 9 ca be  uD  

Second result: Is it vEuD because the first 3 characters (6, 4 and 8) match "648" under "X"?


in this case  vE have the 468   uD have the 9
but thats cross the column
just recognize  vE as it have the 3 DIGITS



Third result: Is it xE because the first and third characters (4 and 8) match "48" under "Y"?



Yes !  xE have the 46
to keep all in one column recognize xE as 46



Fourth result: Is it zC because the first and third characters (4 and 8) match "48" under "Z"?

Yes !
(I suggest work as this for all columns )



Fifth result: I have no idea why it is aBACI


column J but i call this  A (the table as i work it)

number 4689 is in rows  B=44,  then A=66,    then  C=88, then I=99

column J as i call A shows the numbres like DD
but is because it help me   to make it different but is like see  B=4, A=6,C=8,I=9   = 4689

In your workbook example you show the "U" set result for 8857 being uI, I assume that is because "75 " is in the "U" column. Why isn't it uBC because "5" is in the "U" column and "7" is in the "U" column?

In your workbook example you show the "U" set result for 8857 being uI, I assume that is because "75 "  

you are right here. but can be adjust so you can better do uBC

Why isn't it uBC because "5" is in the "U" column and "7" is in the "U" column?

is because i try to get the pairs that come true

This is what I get for U. Please let me know if it is correct.

Yes ! is great

so column B can be same

Let's talk about the third result again. I need to understand in general terms why you show the results you show. In other words you should tell me one or more things like these

Volvamos a hablar del tercer resultado. Necesito entender en términos generales por qué muestra los resultados que muestra. En otras palabras, deberías decirme una o más cosas como estas.

It's a match if any pair in the 4N number matches the ORD value in the X set
It's a match if...
It's a match if...

Please help me understand the question.
Right now how are you formulating it to me, I don't understand it

Do you understand what I mean by "general terms"?

When I asked

Is it xE because the first and third characters (4 and 8) match "48" under "Y"?

you replied

Yes !  xE have the 46

and that uses specific terms.

An explanation using general terms would be something like

It's a match if any pair in the 4N number matches the ORD value in the X set

I'm sorry I want to help but I don't understand

do you want to know the origin

do you want to know the location?

i have to say  the DATA in D28 to D39  is in ORD
but the data in E6 to L17 is not In ORD

but i need match by column so i can find the location of D28 to D39

in the data in E6  to L17

I need you to tell me how you determined that these values are correct.

I don't want you to tell me things like

xE have the 46

but instead something like "a pair in 4689 matches a value in the X set". And if that doesn't result in a match you need to tell me other ways to get a match.

ok

column D 28 to 39  have the ORD

then column X have the pairs

to me is needed Match the ORD DATA to see the location when its shows

I want to see for the repeated location patterns

In general terms so that I can apply it to D29, D30, etcetera, what part of D 28 do I match? First two characters?

In general terms so that I can apply it to D29, D30, etcetera, what part of D 28 do I match? First two characters? 

the situation that I have is the match can be in any position  of the ORD

Are you saying that if any two positions in the ORD match the two characters in the X set then it's a match?

yes!

Good. Can you please remember to state your requirements that way in the future.
Bueno. ¿Puede recordar indicar sus requisitos de esa manera en el futuro?

yes.

My X set results differ from yours. Comments?

is ok  

i see an issue when the pairs repeat

any suggestion from yours is welcome

I have an situation on column L  i name column B


it have 2 section   section a     and b

Will there ever be a value like "11", or "22", etcetera in the X set?

Not

neither will be in any column  

but only in ORD data

but sorry column A shows data as DD  as you say sorry

is the only one

Is the requirement for the Z set similar to te X set? In other words

if any two positions in the ORD match the two characters in the Z set then it's a match?

yes!

I'm not done yet but before I go any further I'd like you to look at my results so far and tell me what is wrong.
Aún no he terminado, pero antes de continuar, me gustaría que mirara mis resultados hasta ahora y me dijera qué está mal.

Have a  Great Rest ! !

Rest is Important Too!

Are my U set results OK? If not then please describe the requirements like you did for the X set.

If not then please describe the requirements like you did for the X set.

IF the digit appear in the first part then  have to be show

if not then look the pairs below

I'm sorry but that doesn't help. What does "Id the digit appear" mean? What is "first part"? What does "if not then look the pairs below" mean?

IF the digit appear in the first part then  have to be show
if not then look the second part

as shows
 

I'm asking about the U set so why are those arrows pointing to the X and A sets?

I'm looking for a description like "if any two positions in the ORD match the two characters in the X set then it's a match".

if any digit (can be more than one appear in the first section  then  have to be shows

if not then match the pairs  in the second section

Are the requirements for Z similar to the requirements for X and Y?

yes

Okay one more.

Please describe the requirements for the 'A' set.

column A set is the  very simple

for example
4689 is aBACI

you see 2 digits in column A  but will get the output as one DIGIT

Try this.
29211358.xlsm

Working Great !!
but will need column B too

Please describe what that means.

ok give me an chance

I did an change so will be more easy for
i create column C  B was already
29211358_to Adjust.xlsm
29211358_to Adjust.xlsm

When do I "read the location from here"?

find the match for ORD in column B and C

Adriana I need to know things like this.

1. When you say "find the match for ORD in column B and C", do I look for each character in the ORD in both the B and C sets?
2. Do I do this for the U, V, X, Y, Z and A sets? If not all of them then which ones?
3. You have 8 in both the B and C columns so should 4869 show B and C (in other words BC). Should 8857 show BBCC?

1. When you say "find the match for ORD in column B and C", do I look for each character in the ORD in both the B and C sets?

need for the characters in column B  then in column C  not together

1. Do I do this for the U, V, X, Y, Z and A sets? If not all of them then which ones?

yes as you did with U, V, X, Y, Z and A sets

you have 8 in both the B and C columns so should 4869 show B and C (in other words BC). Should 8857 show BBCC?

No

need macth each column alone as you did

because they belong from different sources

i never say both columns togethers i just will need columnB then column C each one as we did with columns U, V, X, Y, Z and A sets

It would be easier for me if the were just column B and not B and C. So is it OK if I leave column B the way it is in your original question?

It would be easier for me if the were just column B and not B and C. So is it OK if I leave column B the way it is in your original question?

they have to be apart not togehter
as you did

but need it by each column

ok i see
is ok

i thought i was making it more easier to work

As Always  Great Job !!
Best Expert !