Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Perform functions on the result of adding two columns
Hi there,
I have two columns of data before and after and event and I want to find the median, min, max and quartiles of the change that has occured (after - before). I can easily make another column to calculate the differences and perform the statistics very easily. I already have a lot of columns so I wanted to find ways of saving space and since this is a calculation that I do for a number of variables it would certainly free up columns for me. I have found functions such as sumx2py2 that act in the way that I am looking for, but I do not need to find the sum of the squared differences, I just want to find the minimum of the differences. Are there functions in Excel that can do this? Many thanks Tim Archer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
result is Zero on every maths functions - sum, multiplication ... etc | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |