Randomizing or Shuffling Multiple Cells – Simple Task Tough Formula

[randysiems]

See attached Example and explanation:

Data Range = A1:C1

Need to randomize or shuffle the data range content A1:C1

Place the result into shuffle range content E1:G1

Any pointers, suggestions, formulas or direction is very much greatly appreciated.

Thank You for looking and helping

[micope21]

Hi

Maybe worth have a look at this attachment

[martindwilson]

here is one way

[randysiems]

Hi

Maybe worth have a look at this attachment

Yes - you solution works with perfection, my only challenge is that Im extremely green with excel and I am limited to formulas, the vba will come once this project is complete.

Thank You very much for your help!!

[micope21]

You welcome. Remember it can go from column A1 down to how many row you want

[randysiems]

here is one way

@martin

Your simple solution to my overwhelming simple task has made my day happy. Thanks a million!! You may be interested to know I have only been at the excel workbook / formula for about 1 month. The help from Excel Forum has given me encouragement to continue learning. I will have a couple of additional formula question for this project then it will be complete. I may ask again.

I have been suggested that I should look onto VBA va Formulas, therefore I will be taking that path on my next workbook.

I am using your formula suggestion that you sent me in my current project. Thanks again.