Forum Discussion
nagavardhan1122
Aug 14, 2023Copper Contributor
Need Excel functionality for the random sequence Vlookup
Hi Expert guys, I need Excel functionality with the below data. 1st table contains the below data. 1) 1st table. 2nd table(as below data) - 1st column contains the random arr...
HansVogelaar
Aug 14, 2023MVP
See the attached workbook. I added a helper column to the raw data with RAND() formulas.
The 2nd table uses INDEX and SORT to create a list in random order.
Press F9 to create a new randomized result.