tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tables

Tables

resolvedResolved · Low Priority · Version 2007

Katy has attended:
Excel Intermediate course
Excel Advanced course

Tables

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

RE: Tables

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")

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.08 secs.