| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference Between Highest And Lowest?
If I have a column of numbers from A1:A100 which is constantly being updated, what
formula would I need to put into cell A101 which could calculate the difference between the highest and lowest numbers. Some cells might be blank, which I would choose to ignore rather than be calculated as zero. Thanks. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graph Highest to Lowest. | Excel Discussion (Misc queries) | |||
| Highest High and Lowest Low | Excel Discussion (Misc queries) | |||
| Sort from lowest to highest | Excel Worksheet Functions | |||
| Find lowest and highest value from a set of rows | Excel Discussion (Misc queries) | |||
| How to find highest, lowest and last cell in a row? | Excel Worksheet Functions | |||
Threaded Mode
