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

tables

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

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.