select data 4n TRI and DD

ADRIANA P
ADRIANA P used Ask the Experts™
on
select data by years  canh be
more than one years  at same time

then  create the 13 row set
for the selecet TRI  or DDA  or DDB as needed

as shows
g1.PNG29167322b--2-.xlsm
Comment
Watch Question

Do more with

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

Author

Commented:
2 set before then 10 after  the selection
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 understand what you want, but to be fair to everyone, you should plain more about what you want, particularly where the data comes from.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Data belongs from sheet 1 column  F
but the selector are from TRI  DDA AND DDB
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

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:
Is this what you want for this question?
29167439.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

I like the way it is

but need see the ORD column  and need

have 3 before and 10 after  sets ( 13 rows)
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:
have 3 before and 10 after  sets ( 13 rows)
If for example you are looking for "000", the first hit is in row 167, so what range of weeks do you want to show? 11W2012 to 23W2012?
Si, por ejemplo, está buscando "000", el primer hit está en la fila 167, entonces, ¿qué rango de semanas desea mostrar? 11W2012 a 23W2012?

Do you also want A/P?
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:
This assumes that you want to see 13 weeks that start with the week before the week of the hit, and that you don't need A/P. I also changed the heading in the form to Spanish.

Esto supone que desea ver 13 semanas que comienzan con la semana anterior a la semana del golpe, y que no necesita A/P. También cambié el título del formulario a español.
29167439a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

Great Job

is great as it now

But will need  2 more sets (13 rows) before the selection
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:
Are you saying that when looking for "000", the first hit (row 167), should show weeks 9W2012 to 21W2012?

¿Estás diciendo que cuando buscas "000", el primer hit (fila 167), debería mostrar las semanas 9W2012 a 21W2012?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin  

in the sample row 167

need from 10w2012  to  12w2012  then teh selection in week 13w2012  then 10 sets after
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:
So 10W2019 to 22W2019?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

in this sample you   mention

from 10w2012  to 23w2012


we working 2012 the the row 167
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 understand what you just said. My question is this. For the first hit at row 167 do you want to show weeks 10W2019 to 22W2019?

No entiendo lo que acabas de decir. Mi pregunta es esta. Para el primer hit en la fila 167, ¿quiere mostrar las semanas 10W2019 a 22W2019?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
My question is this. For the first hit at row 167 do you want to show weeks 10W2019 to 22W2019?

should be 10w2012  to 23w2012


you are in  year 2012 in the row 167

not 2019
"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.
29167439a.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