Get Combination Of Unique Values From N Columns Using Rand Or RandBetween Function

[alansidman]

Perhaps if you posted a sample spreadsheet of your data, it would be easier to supply you with a workable solution.

[papabill]

How do I post a sample spreadsheet?

Thanks

[p45cal]

How do I post a sample spreadsheet?

First click Reply or Reply with quote, then click Go Advanced and then click Manage Attachments and follow your nose.

[p45cal]

See attached, an unmanageable and grotesque formula, but it seems to work. There must be a better way. Would a user defined function be acceptable (a macro)?

[papabill]

excel.xlsx

Perhaps if you posted a sample spreadsheet of your data, it would be easier to supply you with a workable solution.