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 *