Help with permutations

[Nanaia]

I have 6 numbers and a letter (1, 2, 3, 4, 5, 6, X) that I need to list in every possible 4 digit combination that includes duplicates (i.e. 1111). Is this possible to do in Excel instead of having to manually type every one? I have seen a couple things online but it deals with Macro's, which I know nothing about. If that's the only way can someone help me learn how?
Regards,
Nanaia

"Do or do not, there is no try"~Yoda

 

[Gerald Higgins]

Hi, welcome to the board.

Here's one non-VBA method.

Took me about 5 minutes.

In cell A2, enter the value 1111, AS TEXT.
In cell A3, enter the value 1112, AS TEXT.

Select the range A2:A3, and then use Excel's Drag and Fill feature to fill the range down to about row 9000.

You should now have the range A2:A9000 filled with numbers from 1111 to a little over 10,000, though they should all really be TEXT STRINGS.

Then, use Edit, Find and Replace to Find all instances of the digit "7", and replace with "X".

Then, apply a data filter, to filter all values containing the character "8", and delete them.
Repeat for the character "9".
Repeat for character "0".

And that should be it.

 

[Nanaia]

Works for me! Saves my wrist from typing. Thanks!

Nanaia
"Do or do not, there is no try"~Yoda