I drag down the formula to the desired position and I get random data to do some practice work. So yeah guys! This is the way you can randomize a list in Excel. Feel free to ask the question in the comments section below. Related Articles: ...
2) Sample Data - Suggested UseUse this data to demonstrate lookup formulas, such as VLOOKUP, XLOOKUP, INDEX and MATCH. Also, you could show how to create dependent drop down lists, for category and food item. See the Excel Daily Calorie Counter page for an example. ...