Create Random Groups using Excel




About this tutorial:

Video duration: 3:52
You can download the template here:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

6 thoughts on “Create Random Groups using Excel

    Colby York

    (February 1, 2019 - 8:09 am)

    I know Google Sheets handles it this way, but I didn't have time to test on Excel, but if you Conditionally Format the cells to the desired color based on the criteria "cell is not empty", those conditions are set to the specific cells in an absolute manner and not relatively so sorting will leave (in your example) cells H4:H7 formatted to x color as long as there is a value inside.

    WoodStock M-79

    (February 1, 2019 - 8:09 am)

    Really Big help for me

    LilyBlue

    (February 1, 2019 - 8:09 am)

    This is great, thank you!

    Vix

    (February 1, 2019 - 8:09 am)

    So helpful and straight to the point. Thanks very much!

    Richard Li

    (February 1, 2019 - 8:09 am)

    This is really fantastic and helpful! Thank you for the video!

    Daanz82

    (February 1, 2019 - 8:09 am)

    Helpful video, cheers mate!

Leave a Reply

Your email address will not be published. Required fields are marked *