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