button to selct range option in 4N WK

click the Range Pairs 3s

then have the option to
have any range as needed  show an put together in column CG
29085099a--3-_w_range_4N_t_improve.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Do you mean that you want to change the number of pair ranges that are shown in column "GC"?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Do you mean that you want to change the number of pair ranges that are shown in column "GC"?

Yes to show as needed!
0
Martin LissOlder than dirtCommented:
Is this for all weeks. In other words for the whole column?
1
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

Is this for all weeks. In other words for the whole column?

Yes!
0
Martin LissOlder than dirtCommented:
How about this then? Currently when you click the 'Range Pairs 3s' button it assumes you want to concatenate the highest 3 pair ranges. How about if I have that button ask you how many range pairs you want to see? After that's done and you see the results, will you ever want to change just one or two of the weeks?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

How about if I have that button ask you how many range pairs you want to see?

that will be great


After that's done and you see the results, will you ever want to change just one or two of the weeks?

Martin don't understand this question !!
0
Martin LissOlder than dirtCommented:
Ok, you click the button and you ask to see 2 pair groups. When it's done you'll see something like this. Would you ever want to change just the result by the arrow to show 3 or 4 (or more) pair groups.
2018-02-22_16-40-49.png
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
 
Would you ever want to change just the result by the arrow to show 3 or 4 (or more) pair groups.

yes i think 3 or more as needed when needed  ( any time )
0
Martin LissOlder than dirtCommented:
OK.
1
Martin LissOlder than dirtCommented:
Try this. When you click the button you'll be asked how many range pairs you want to see. After that's done you'll see cells that looks like a button and say "Change". If you click on the "Change" cell you can ask to see however many range pairs that you want,
29085562.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
working as needed

Great job  Best Expert !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.