In this section, we will make our random selection of the unique products without the need for the random numbers with the help of the INDEX function, SORTBY function, RANDARRAY function, ROWS function, and SEQUENCE function. Method-4: Using Combination of INDEX, SORTBY, RANDARRAY, ROWS, and SEQUENCE Functions Read More: Random Selection Based on Criteria in Excel (3 Cases) Įventually, we made our random selection of 6 products among the 9 products avoiding any duplicate selection. INDEX($B$4:$B$12,6,1) → INDEX returns the value of cell B9 at the intersection of Row 6 and Column 1 in the range $B$4:$B$12. ➤ For generating random unique numbers apply the following function in the cells of the Random Value column. To do this we will be using the combination of the RAND function, INDEX function, RANK.EQ function, and COUNTIF function. Here, we will choose any 6 unique products from the list of the Product column randomly and then muster them in the Random Item column with the help of some random numbers. Method-3: Random Selection with No Duplicates Using RAND, INDEX, RANK.EQ, and COUNTIF Read More: How to Select Random Sample in Excel (4 Methods) The UNIQUE function and the RANDARRAY function are available only for Microsoft Excel 365 and Excel 2021 versions. In this way, we have done our random selection of the products without duplicates in the Random Item column. ➤ Press ENTER and drag down the Fill Handle tool. INDEX($B$4:$B$12,8,1) → INDEX returns the value of cell B11 at the intersection of Row 8 and Column 1 in the range $B$4:$B$12.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |