Скачать с ютуб Randomly Assign Your Excel Data into Groups в хорошем качестве

Randomly Assign Your Excel Data into Groups

In this video, we explore multiple ways to generate random group assignments for our data. We will start with a shorter solution that requires two columns, but can cover any number of items in your data column. Next, we build a static, single-column solution that’s great when you know the number of datapoints. Lastly, we expand the single-column solution to end up with a single-column equation that can flex with the number of rows. TIMESTAMPS: ==================== 0:00 Introduction 0:20 Outline 1:14 Solution 1 4:07 Solution 2a 9:46 Solution 2b 12:42 Summary 12:42 Wrap up EXCELSMITH LINKS: ==================== Unique Random Numbers (Not Excel 365):    • Create a List of Unique and Random Nu...   Custom Array Using INDEX:    • Create Custom Arrays Using INDEX in E...   MICROSOFT LINKS: ==================== COUNTA: https://support.microsoft.com/en-us/o... COUNTIF: https://support.microsoft.com/en-us/o... IF: https://support.microsoft.com/en-us/o... INDEX: https://support.microsoft.com/en-us/o... LARGE: https://support.microsoft.com/en-us/o... RANDBETWEEN: https://support.microsoft.com/en-us/o... ROUNDUP: https://support.microsoft.com/en-us/o... ROW: https://support.microsoft.com/en-us/o... SUM: https://support.microsoft.com/en-us/o... MICROSOFT KEYBOARD SHORTCUTS: https://support.microsoft.com/en-us/o... UNSPLASH IMAGE: ==================== Photo by Mitchell Luo on Unsplash