how to sort multiple columns in excel 2003

Select a button from the Forms toolbar and place it anywhere on the worksheet. Select Data » Sort and sort the data by column A. Select columns A, B, C, and D and press F9 (to force a recalculation). Then select any single cell and select Tools » Macro » Record New Macro.

Enter =RAND( ) in cell A2 and copy down as far as needed. First, place the heading RAND in cell A1. You then can attach this macro to a button so that each time you want to draw three winners, all you need to do is click the button and use the top three names.įor example, assume you have your data in columns B, C, and D and that row 1 is used for headings. However, you can use this volatility to your benefit and record a macro that sorts data immediately after you recalculate and force the RAND function to return another set of random numbers. You'd better write down your winners quickly. The RAND function is a volatile function that will recalculate automatically whenever an action takes place in Excel-e.g., entering data somewhere else, or forcing a recalculation of the worksheet by pressing F9. In other words, you can sort columns A, B, C, and D by column A in either ascending or descending order, and the three winners can be the top three names. As soon as you do this, each cell in column A containing the RAND function will automatically return a random number by which you can sort the table. You can place the RAND function in cell A2 and copy this down as many rows as needed, all the way to the end of your table. Assume you have a three-column table in your spreadsheet, starting from column B and containing Name, Age, and ID No., in that order.

How to sort multiple columns in excel 2003