Tables

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

Resolved · Low Priority · Version 2007

Tables

Katy has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Katy [3 posts] (2008 Apr 29 Tue, 16:13) Reply

How do you put something in a table that is greater than and less than then sort it out it order.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Tables

by - trainer Rich platinum contributer [654 posts] (2008 May 15 Thu, 20:38) Reply

hi
Not sure i understand the question. After you put data in a table you can sort the entire table using the Sort functionality by highlighting the table and using data>>sort.

Do you mean that you want a column which is a result based on an if statement? for example a formula that says if a value is less than 5 put 'small' in the cell? This would be a formula such as:

=IF(C8<5,"Small","medium")

· Microsoft Excel Training: Essential for Today's Employees
· Do You Really Need Excel VBA Training?
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training Course

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips