We help IT Professionals succeed at work.

count each digit 3n permutation

69 Views
Last Modified: 2018-09-14
count each digit  in column A

in DTA sheet area
29117390_to_count_eah_digit_to_3n_p.xlsm
Comment
Watch Question

Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
On what sheet?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
DTA
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please supply a workbook that has data in the DTA sheet.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
ok
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Try this.
29117392.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
sorry

but the guides lines numbers disappears

Best Expert!

d111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
when test it with data
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Is this better?
29117392a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
sorry  still the same issue

why ?
the guides numbers  disappears
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please describe the steps, one by one, that you do.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
Social distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Working as needed !
Great JOb !
 The Best !
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Thank you for my 6 millionth point!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Here to help !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
sorry im getting this error
when i paste the data then press onecolumn button to make the one column in DTA column A

d1111.PNG
f1111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Also when i try to clean the data in MtoONEsheet

i press the clean button but

stll data like show here
g11111.PNG
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please attach the workbook that has the new data.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Working as needed
 Great JOb !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
now the count button is not working

and take long tine to find the pairs when press pair button
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
why  05 is not counting ??

llllll111111.PNG3n_permutation_need_fix.xlsm
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !
 Best Expert !
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
;)
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.