answersLogoWhite

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.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

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.


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.


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 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.


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.


When does Amazon charge for orders?

Amazon charges for orders when the items are shipped or when they are ready for digital download.


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 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.