# Create the Keys for selection

on
need create the key and the count for

as show here

h1.PNG
29168287.xlsm
Comment
Watch Question

Do more with

EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ACCOUNTING ASSISTANT

Commented:
here an error in this file

"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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.
ACCOUNTING ASSISTANT

Commented:
ACCOUNTING ASSISTANT

Commented:
ACCOUNTING ASSISTANT

Commented:
Also please show me the correct numbers for all of row 1669.
ACCOUNTING ASSISTANT

Commented:
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Clever picture.

What numbers go in S1669?
ACCOUNTING ASSISTANT

Commented:
What numbers go in S1669?
2125676567
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
ACCOUNTING ASSISTANT

Commented:

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

ACCOUNTING ASSISTANT

Commented:
In column G by week

need pickup  the more tha one range  pair

then create the key
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ACCOUNTING ASSISTANT

Commented:
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
ACCOUNTING ASSISTANT

Commented:
others way to say is we in the key 2125676567
just repeat the range number one
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Try this.
29168360.xlsm
ACCOUNTING ASSISTANT

Commented:
Martin Greatest Expert !!

is an great Job !

but i have one situation

ACCOUNTING ASSISTANT

Commented:
need add an counter for each key

that why an blank space was left
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
but i have one situation
So 253 should be 235?
ACCOUNTING ASSISTANT

Commented:
So 253 should be 235?

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

Commented:
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
What should 253 be?
ACCOUNTING ASSISTANT

Commented:
What should 253 be?

q quieres decir ?
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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.
ACCOUNTING ASSISTANT

Commented:
ok i see sorry

the correct pic should  be this

ACCOUNTING ASSISTANT

Commented:
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)
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
29168360a.xlsm
ACCOUNTING ASSISTANT

Commented:
Great JoB Best Expert !
ACCOUNTING ASSISTANT

Commented:
Martin

this file  29168360a.xlsm

show this message
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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,

Do more with