| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I sort an excel worksheet with the if-then features?
How do you sort an excell sheet using a formula such as: IF (value) is less
than, then (value). If (value) is greater than, then (value)? |
|
#2
|
|||
|
|||
|
Could you explain a bit more what you want to do?
You can use a help column with formulas and sort by the results of the formulas Otherwise unless you mean sorting lower to higher or reversed I have no idea what you mean by sorting using IF function? Regards, Peo Sjoblom "Carlyne" wrote: How do you sort an excell sheet using a formula such as: IF (value) is less than, then (value). If (value) is greater than, then (value)? |
|
#3
|
|||
|
|||
|
Thanks you for the reply. I found the answer, what I was referring to was
the conditional formatting under the format tab. "Peo Sjoblom" wrote: Could you explain a bit more what you want to do? You can use a help column with formulas and sort by the results of the formulas Otherwise unless you mean sorting lower to higher or reversed I have no idea what you mean by sorting using IF function? Regards, Peo Sjoblom "Carlyne" wrote: How do you sort an excell sheet using a formula such as: IF (value) is less than, then (value). If (value) is greater than, then (value)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
| How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
| Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Linear Mode
