Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

create the key for the selection by week

create an key when the week have same range pair

for example   as show here
User generated image29168056a.xlsm
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

What would the result be for row 278?
Avatar of ADRIANA P

ASKER

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Martin

after i hit the pair button to test it

it just show blank from G to J column
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?
Do you agree?
yes
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.
Great Job Best Expert !