Create the Keys for selection

here an error in this file

You didn't attach a workbook.

Why is U2101 = 253 and why is W1201 = 530? Where do 253 and 530 come from?

Also please show me the correct numbers for all of row 1669.

No adjuntaste un libro de trabajo.

¿Por qué es U2101 = 253 y por qué W1201 = 530? ¿De dónde vienen los 253 y 530?

También muéstreme los números correctos para toda la fila 1669.

Also please show me the correct numbers for all of row 1669.

Clever picture.

What numbers go in S1669?

What numbers go in S1669?

2125676567

I should have asked why.

I should have asked why.

because  always ascendent order

in this case  20 range and 60 range have more than one so we need  both

then we select  them

we will need all the range numbers

In column G by week

need pickup  the more tha one range  pair

then create the key

I don't think you understand what I'm asking.  Q1669 contains 2122252627656667 which I understand, but in S you show 2125676567. Why is S that value?

No creo que entiendas lo que te estoy preguntando. Q1669 contiene 2122252627656667 que entiendo, pero en S muestra 2125676567. ¿Por qué S es ese valor?

Why is S that value?

we resume  taking the first range number that repeats  

example  2122252627656667

20 and 60 range show more than one  so me make 2122252627656667

then the key 2125676567  because we select the 2 because the range and the others are the followings  digits

others way to say is we in the key 2125676567  
just repeat the range number one

Try this.
29168360.xlsm

Martin Greatest Expert !!

is an great Job !

but i have one situation
 

need add an counter for each key

that why an blank space was left

but i have one situation

So 253 should be 235?

So 253 should be 235?

not  the order area from down to up and can not be alter

What should 253 be?

What should 253 be?

i don't understand your question

q quieres decir ?

You said "but i have one situation" and you pointed to a cell in the 1KEY column that has a value of 253 in row 1201. Starting from the bottom up, the values in column 'K'  are 20, 50, 30 and that's why I put 253. If 253 is wrong, what should it be?

We frequently have this problems like this where you tell me something if wrong but you don't tell me what it should be.

Usted dijo "pero tengo una situación" y señaló una celda en la columna 1KEY que tiene un valor de 253 en la fila 1201. Comenzando de abajo hacia arriba, los valores en la columna 'K' son 20, 50, 30 y por eso pongo 253. Si 253 está mal, ¿qué debería ser?

Frecuentemente tenemos este tipo de problemas cuando me dices que algo está mal pero no me dices qué debería ser.

ok i see sorry

the correct pic should  be this

Martin the values you did are ok

im talking about the blank columns between values

bacuse i need add an counter or each key (values)

Great JoB Best Expert !

Martin


after added new years data

this file  29168360a.xlsm

show this message

The new data is probably the wrong format so I need to see the workbook with the new data,

Los nuevos datos probablemente tengan un formato incorrecto, así que necesito ver el libro de trabajo con los nuevos datos,