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

asked on

4n to create keys from full range

4n  wWKTPNVERTY Lookup to add RANGE keys
29219631.xlsb


as we did here  but now for RANGE
https://www.experts-exchange.com/questions/29219434/4n-to-create-keys-from-TP-vertically.html


1- create the  range  HOR key  Range HORI

2- create the vertical key   Range VERTI


Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

may be i will need help with range because i may did an error
User generated image
can you see what i means ?
line 10 should be the begining for all   then fill the not shows so it can be take in count
Avatar of Martin Liss
Okay I assume that for this question you want me to change the way Week Range is done and not do anything with the range keys yet. If so then please show me what 1W2012 should look like including what TK and LK should be. Don't worry about the colors.

De acuerdo, supongo que para esta pregunta desea que cambie la forma en que se realiza el rango de la semana y no haga nada con las teclas de rango todavía. Si es así, muéstreme cómo debería verse el 1W2012, incluido lo que deberían ser TK y LK. No se preocupe por los colores.
ok give me an chace to do it
should be like thisUser generated image

Thanks.
;)
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
Great Job
Best expert !!

then need create the Keys