0
Just use =RAND() to generate random numbers in your list. Then you can sort it with the random numbers.
Comments on answer:
Let's just say the list is in column C and has 12 entries. Your answer says to "just use =RAND() to generate random numbers in your list". OK, so where "in the list" would I put the =RAND() function command? And in which cells would that function display the "random numbers in my list" that you suggest?
And then, how would I go about sorting "it" with the random numbers that somewhere have been generated?
Sorry for being the devil's advocate, but I just want to get clear info on how to do the task you answered.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is vlook up?
Vlook up is the formula in microsoft excel to search the list of items vertically to find out specific information.
What is a Datasheet?
The data sheet view in Microsoft SharePoint is a useful tool for quickly editing several list items. It functions similar to an Excel spreadsheet and can be exported to or imported from an Excel spreadsheet.
What is the purpose of datasheet view?
The data sheet view in Microsoft SharePoint is a useful tool for quickly editing several list items. It functions similar to an Excel spreadsheet and can be exported to or imported from an Excel spreadsheet.
What formula in Microsoft excel would compute a total cost with tax?
=SUM(A1:A12)*.065 [assumes A1:A12 contains the purchased items and the tax rate is 6.5%]
How do you upload an Excel spreadsheet of multiple items into Microsoft RMS?
There is a basic tool available to import various file formats, including Excel into Microsoft Dynamics Retail Management System (RMS). Recommend you contact your RMS Partner who sold you the system to see if your license includes that import tool. See related links for more information about RMS.
Is there a limit to the number of items you can put in an Excel formula?
Yes. Excel 2003 and earlier limit is 254. Excel 2007 limit is 16,000.
How does grouping work in Microsoft Excel?
Grouping can refer to taking blocks of data with similar headings and bringing them together. It can refer to selecting more than one worksheet at the same time. It can refer to grouping graphical items together into one item.
Data items that make up a record in excel are called?
Fields.
Place in computers memory to collect items excel?
Office ClipBoard
How many items can be held in the clipboard for Microsoft 2010?
24
What does average item revenue mean on Excel?
The revenue is how much is earned on each item. If you total up the revenue of all items and then divide by the amount of items there are, you will get the average revenue. You could use the Average function in Excel to do this.
What is a graphic in Excel?
Within Excel you can draw all kinds of different shapes and other items. They are graphics. The charts and diagrams that Excel can create are also graphics. Even the icons you click on are graphics.
