Select similiar range numbers 4N

ADRIANA P
ADRIANA P used Ask the Experts™
on
create the key

fom column G  only the same range in this sample 40 is the range

with the same range digit

example  40 41 42 ect...

as show

aa1.PNG4N_pair_range.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Posting an xlsx file doesn't help us. Please open your source workbook, make any changes you need and then save it as an xlsm file.

Publicar un archivo xlsx no nos ayuda. Abra su libro de trabajo de origen, realice los cambios que necesite y luego guárdelo como un archivo xlsm.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
here the source  for 4N
4n_code_file_range.xlsb
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

4N_pair_range.xlsx  is the file needed  to wrk with

4n_code_file_range.xlsb  is the source and have the code to work with
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
That's not what I need.It does not contain the code that puts results in columns 'G' to 'O' and if I were to update 4N_pair_range.xlsx  to do what you now want, you would not be able to ever see results in those columns if you for example added a week or changed an ORD. I assume you created 4N_pair_range.xlsx from some xlsm workbook. I need that xlsm workbook.

Eso no es lo que necesito. No contiene el código que pone los resultados en las columnas 'G' a 'O' y si tuviera que actualizar 4N_pair_range.xlsx para hacer lo que ahora quiere, no podría ver resultados en esas columnas si, por ejemplo, agregó una semana o cambió un ORD. Supongo que creó 4N_pair_range.xlsx de algún libro de trabajo de xlsm. Necesito ese libro de ejercicios xlsm.
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I will work with what I have.
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this.
29168524.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Best EXpert !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin the

range is not working as needed

this the las you did
a1.PNG


and this the original file in the sourceyou did too

and is more complete than the last one

a11.PNG
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I'm sorry but I don't know what you mean. Please refer to workbooks by name and give me details about what is wrong.

Lo siento pero no sé a qué te refieres. Consulte los libros de trabajo por nombre y bríndeme detalles sobre lo que está mal.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

 the file 29168524.xlsm

have the range working but not properly
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
when you compare  to range in 4n_code_file_range.xlsb

the range in file 4n_code_file_range.xlsb is more complete  and more reliable
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I assume that you're talking about week 13W2014. In that week (and every week) the ORD data for the workbooks is different, so it makes no sense to compare the results. If you think the results of week 13W2014 in workbook 29168524.xlsm are incorrect then please show me what they should be.

Supongo que estás hablando de la semana 13W2014. En esa semana (y todas las semanas) los datos de ORD para los libros de trabajo son diferentes, por lo que no tiene sentido comparar los resultados. Si cree que los resultados de la semana 13W2014 en el libro 29168524.xlsm son incorrectos, muéstreme cuáles deberían ser.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

the are the same  because the belong from the same source

please verify it

is the same data but have to be work  in diferents ways !
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
My mistake. I will fix it.
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
For column 'L', how many "80"s are there in 8877?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
80  =

88  87
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Okay thanks. I asked because in the range in 4n_code_file_range.xlsb file cell CF1519 shows 3.

Try this.
29168524a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB ! best Expert !

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