I`m looking for a formula or anything really to get the following done.
I manually list stuff in Column from Sheet 2 and whether automatically or not I can get those entries sorted in unique combinations with entries based in B2 ,D2 ,F2 ,H2 & J2 in a different sheet -> sheet 1. These combinations must be unique but I dont want it to repeat combinations in the sense that once I have AAAAB I dont want AAABA, AABAA, ABAAA & BAAAA. Also it doesnt matter which of those I get so long as I get just one of them.
What`s do you think of this? This is just an example question,
Untitled.png
Bookmarks