| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use functions after sorting a range?
=AVERAGE(A1:A100)
=STDEV(A1:A100) =MEDIAN(A1:A100) "R13" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use functions after sorting a range?
My mistake. I meant filter not sort. I want to use these same functions with
filtered data. Thanks for the reply nonetheless. "Teethless mama" wrote: =AVERAGE(A1:A100) =STDEV(A1:A100) =MEDIAN(A1:A100) "R13" wrote: 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. |
| Reply |
| 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 | |||
Hybrid Mode
