excel programming vba - Sorting

The UK's most regular instructor-led training courses.
Training information: excel programming vba · Microsoft excel training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Sorting

Sean has attended:
Excel Advanced course

by - delegate Sean [1 post] (2007 Mar 21 Wed, 16:04) Reply

How do you sort data?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: sorting

by - trainer Amanda platinum contributer [968 posts] (2007 Mar 22 Thu, 15:23) Reply

Sean

Simply select the data you want to sort, then click the A-Z or Z-A button on the toolbar.

You can also access more detailed options under the Menu bar by clicking DATA, then SORT.

Richard

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Advanced Excel Training - takes you to the next level
· Microsoft Excel Training Course
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips