ADRIANA P
asked on
need count all combination
How is this different to the question that I have just answered?
ASKER
Shums Thanks !
what i really mean is an number for example
123 132 231 213 321 312
all the coombination of the same digits
what i really mean is an number for example
123 132 231 213 321 312
all the coombination of the same digits
ASKER
Roy_Cox thsnk ! is not just an single number as well
ASKER
I have to say i need count each combination
for example 123 how many
321 how many
213 how many
but the all belong from 123 same digits
for example 123 how many
321 how many
213 how many
but the all belong from 123 same digits
I'm not sure if a function would do this.
ASKER
Roy_Cox thanks !!
This looks at every row. Do you want that?
29024084.xlsm
29024084.xlsm
ASKER
Martin !! i did not understand
I open the file nothings happens
yes a need look all rows of data with
I open the file nothings happens
yes a need look all rows of data with
So you want to enter some characters determine all the Permutations then count all the instances in your spreadsheet. Is that it? If it is, it should be possible.
Go to Module1 and run the CountAll macro.
This version adds a button and shows you the matches.
29024084a.xlsm
29024084a.xlsm
ASKER
Preddie Partap sound interesting
ASKER
Martin it say 2 courrences but
whay i need is to count all the combination for an given number
i need the count lik in an new sheet like preview
whay i need is to count all the combination for an given number
i need the count lik in an new sheet like preview
ASKER
could be an butoms so i enter the number and it give the count of all the combinatons in the column ?
Please attach a workbook that shows what you want after looking for "903".
ASKER
ok doing now !
ASKER
Here !
29024084--2-.xlsm
29024084--2-.xlsm
ASKER
when i enter number like 903 need to count all combination of the 3 numbers in the column (G) with the data
and in result sheet show the count of 930 903 309 390 039 093
and in result sheet show the count of 930 903 309 390 039 093
Why is "93" being counted?
If you want "93" counted, then why not count "39", "90", "30", ect.?
If you want "93" counted, then why not count "39", "90", "30", ect.?
ASKER
number in column G will be increase i just put some samples numbers but there will be like over 3000
ASKER
not is 93 is 093 but the program show as 93 not 093
to be show as 093 have to be format as text
to be show as 093 have to be format as text
ASKER
is 093
ASKER
the problems is when an 0 is first position it don't show up
ASKER
in this case I need look for the combinations of the 3 numbers it will give 6 numbers combination
OK, I understand.
Try this.
29024084b.xlsm
29024084b.xlsm
ASKER
Martin an little issue
mark in red
when use the find tool it say 6 but it count 5
and happens some times with others numbers not always
i think cab be somting about the range or txt issue
TEST.xlsm
mark in red
when use the find tool it say 6 but it count 5
and happens some times with others numbers not always
i think cab be somting about the range or txt issue
TEST.xlsm
ASKER
when you look 629 withth find tool say 6 but it count 5
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great JOB !