improve solution reponse time

ADRIANA P
ADRIANA P used Ask the Experts™
on
have situation with this

solution take too much time
can be improve ??

1-i hit  PERMUTATION

take long time

2- then i hit  convert pair
than it take hours  to count

need be in less time as posible
count_all_to_adjust.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
'Permutations' is still slow, but I changed it so that you don't need the 'Convert Pair' button.
29115798.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