create the key for the selection by week

ADRIANA P
ADRIANA P used Ask the Experts™
on
create an key when the week have same range pair

for example   as show here
f1.PNG29168056a.xlsm
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:
What would the result be for row 278?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
g1.PNG
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this.
29168257.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

after i hit the pair button to test it

it just show blank from G to J column
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You should have clicked the 'Count ranges by Week button'. Try that now, but maybe we should have just one button that is called something like 'Update'. Do you agree?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Do you agree?
yes
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Okay then if the 'Count ranges by Week' button does what you want then please close this question and ask another one about fixing the 'Pair' button since I did not make any changes to that button.

De acuerdo, entonces, si el botón ''Count ranges by Week' hace lo que desea, cierre esta pregunta y pregunte a otra sobre cómo arreglar el botón 'Emparejar', ya que no hice ningún cambio en ese botón.
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