# defining a range subset based on a primary range for use in Median and Mode functions

1. ## defining a range subset based on a primary range for use in Median and Mode functions

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

2. ## Re: defining a range subset based on a primary range for use in Median and Mode functions

Try these array formulas**:

=MEDIAN(IF(A22:A250>1000,A22:A250))

=MODE(IF(A22:A250>1000,A22:A250))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1