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

asked on

count each digit 3n permutation

count each digit  in column A

in DTA sheet area
29117390_to_count_eah_digit_to_3n_p.xlsm
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

On what sheet?
Avatar of ADRIANA P

ASKER

DTA
Please supply a workbook that has data in the DTA sheet.
ok
Which sheet should the output go to?
Is there an existing button you want to use?
If not then on which sheet should the button be?
Which sheet should the output go to?

dta

Is there an existing button you want to use?

no. an new one is needed

If not then on which sheet should the button be?

dta
sorry

but the guides lines numbers disappears

Best Expert!

User generated image
when test it with data
Is this better?
29117392a.xlsm
sorry  still the same issue

why ?
the guides numbers  disappears
Please describe the steps, one by one, that you do.
1- clean old data -- clean all in  DTA  -- the guides numbers too

2- add new data

3- click PAIR

4 click count

5- count show but guides are gone
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
Working as needed !
Great JOb !
 The Best !
Thank you for my 6 millionth point!
Here to help !
sorry im getting this error
when i paste the data then press onecolumn button to make the one column in DTA column A

User generated image
User generated image
Also when i try to clean the data in MtoONEsheet

i press the clean button but

stll data like show here
User generated image
Please attach the workbook that has the new data.
SOLUTION
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
Working as needed
 Great JOb !
now the count button is not working

and take long tine to find the pairs when press pair button
why  05 is not counting ??

User generated image3n_permutation_need_fix.xlsm
SOLUTION
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 !
None of the pivot tables work. They were not my code and I know very little about them so if you want to get them working you'll need to ask a new question and hope the person who coded them or some other Expert can help you.
;)