| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find Median of Positive numbers only in Range
I have a column containing both positive and negative numbers
I need a formula to find the Median of all positive numbers, and a separate formula to find the Median of all negative numbers Any help gratefully acknowledged |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum only positive numbers | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
