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
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

On what sheet?
ASKER
ADRIANA P

DTA
Martin Liss

Please supply a workbook that has data in the DTA sheet.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
ADRIANA P

ok
Martin Liss

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?
ASKER
ADRIANA P

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

Martin Liss

Try this.
29117392.xlsm
ASKER
ADRIANA P

sorry

but the guides lines numbers disappears

Best Expert!

d111.PNG
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
ADRIANA P

when test it with data
Martin Liss

Is this better?
29117392a.xlsm
ASKER
ADRIANA P

sorry  still the same issue

why ?
the guides numbers  disappears
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Please describe the steps, one by one, that you do.
ASKER
ADRIANA P

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
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ADRIANA P

Working as needed !
Great JOb !
 The Best !
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Martin Liss

Thank you for my 6 millionth point!
ASKER
ADRIANA P

Here to help !
ASKER
ADRIANA P

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

Also when i try to clean the data in MtoONEsheet

i press the clean button but

stll data like show here
g11111.PNG
Martin Liss

Please attach the workbook that has the new data.
ASKER
ADRIANA P

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

Working as needed
 Great JOb !
ASKER
ADRIANA P

now the count button is not working

and take long tine to find the pairs when press pair button
ASKER
ADRIANA P

why  05 is not counting ??

llllll111111.PNG3n_permutation_need_fix.xlsm
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

Great Job !
 Best Expert !
Martin Liss

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.
ASKER
ADRIANA P

;)
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy