| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find the largest change of values in a column
I need to know if there is a way to find the largest change in a single
column of numbers, even if they are negative values. EXAMPLE: Column A1:A3 contains the following numbers 135.67 23.45 -256.77 I need to show the returned information in Cell B6. Every function I use returns 135.67 as the largest but I need to return the -256.77, (and show the negative sign). This is a very simple example but I hope someone can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Find values in a column | Excel Discussion (Misc queries) | |||
| find the largest number in column | Excel Discussion (Misc queries) | |||
Threaded Mode
