I'm new here, so I hope I'm folloing the proper protocols.
My probelm is this: I have a "master range" ( a single column, Say A22 to A 250 - A22:A250), sorted highest value to lowest value and I want to run median and mode functions. All cells in the master range are results of other calculations. I would like to run Median and Mode functions on the column for only those cells having a value greater than 1000. Depending on the time of day, any particulare cell may go from 0 to 1500.
Ergo, I'd like to be able to say " from this master range of A22:A250 give me the median of ( or for) ony those cells whose current value is greater that 1000 ( the "subset range").
Thanks in advance, Araise