Create the Keys for selection

ADRIANA P
ADRIANA P used Ask the Experts™
on
need create the key and the count for

as show here

h1.PNGh1.PNG
29168287.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
here an error in this file

h12.png
Martin Liss"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.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
j1.PNG
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
k1.png
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Also please show me the correct numbers for all of row 1669.
m1.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Capture.PNG
Martin Liss"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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
What numbers go in S1669?
2125676567
Martin Liss"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 should have asked why.
ADRIANA PACCOUNTING ASSISTANT

Author

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

r1.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
In column G by week

need pickup  the more tha one range  pair

then create the key
Martin Liss"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?
ADRIANA PACCOUNTING ASSISTANT

Author

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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
others way to say is we in the key 2125676567  
just repeat the range number one
Martin Liss"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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin Greatest Expert !!

is an great Job !

but i have one situation
 

t1.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
need add an counter for each key

that why an blank space was left
Martin Liss"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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
So 253 should be 235?

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

Author

Commented:
x1.PNG
Martin Liss"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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
What should 253 be?

i don't understand your question

q quieres decir ?
Martin Liss"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.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
ok i see sorry

the correct pic should  be this

t1.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

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:
Added columns.
29168360a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB Best Expert !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin


after added new years data

this file  29168360a.xlsm

show this message
w1.PNG
Martin Liss"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

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial