Permutation

[viquar]

I am having set of 4*4 like A,B,C,D and I get the answer also by using CHAR
I need to shortlist the total list kike AAAA,AAAB,AAAC,AAAD....DDDD IN THE ABOVE CASE AAAA,AAAB,AAAC,AAAD I NEED ONLY ONE EITHER IT IS AAAA,AAAB,AAAC OR AAAD.

THIS IS USING FOR CROSSWORD PUZZLE ONE ERROR FORMULAE CAN ANYBODY SOLVE THIS PROBLEM

[zbor]

Can you upload example workbook with your inputs and desired output?

[viquar]

I upload the file