Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use functions after sorting a range?
I would like to use functions to get values of columns that have numbers in
them after sorting them. For example, after sorting, I would like to find the average, standard deviation or mean for the numbers in the column. Please advise how to do this. Currently, my method includes all cells in the range, not just the sorted ones. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a Range | Excel Discussion (Misc queries) | |||
Sorting By a range of rows | Excel Discussion (Misc queries) | |||
sorting a range | Excel Discussion (Misc queries) | |||
Sorting a Concatenated Range | Excel Worksheet Functions | |||
Sorting a portion of a range | Excel Worksheet Functions |