Ethan Hova

Ethan Hova

Posted: November 7, 2007 03:07 PM

Instructions on how to sort in Excel

digg Share this on Facebook Huffpost - stumble reddit del.ico.us RSS
Read More: Offthebus, Wnyc, Home News

Instructions on how to sort with excel:

Make sure you have the entire spreadsheet selected by clicking on the box on the upper left hand corner of the spreadsheet, then click on the Data drop-down window and select Sort. In the dialogue box that opens, make sure the radial next to Header Row is selected, then choose up to three columns to sort by. For example, if you're trying to find how much money was donated after a specific online fundraising appeal, you might want to sort the spreadsheet by Date, then Quarterly Contribution. If you're trying to correlate the money raised in a specific state after Bill Clinton attended a fundraiser there, you might want to sort the data by State, then Date, then Quarterly Contribution.

If you're worried the sort went wrong, please double-check a line in the sorted document against the original. Any questions? Contact me at ethanotb@gmail.com

 
Comments
0
Pending Comments
0
iPhone App Promo

Want to reply to a comment? Hint: Click "Reply" at the bottom of the comment; after being approved your comment will appear directly underneath the comment you replied to

View Comments:
Comments are closed for this entry

 You must be logged in to comment. Log in  or connect with 

Connect