Trying to Get Median Based on Dates and Duplicate Values

[monicamarie]

Hello,

I am trying to find a formula that will produce the results below for the median. My array table is sorted by the Purchase Date from ascending to descending. I am basically trying to find the median date range based on the Purchase Date where all unique values from the Inventory Code column are included. In my example below the date range I need is from 2/6/13 to 2/19/13. I'm not quite sure how else to explain this so hopefully I am making sense. Is there a formula that will produce this result? It doesn't have to be like the example below where the result is showing in column C as "Median". I just need to somehow come up with a way to get the answer 2/6/13 to 2/19/13.
Thank you.

1<o></o>​	A<o></o>​	B<o></o>​	C<o></o>​
2<o></o>​	Inventory Code<o></o>	Purchase Date<o></o>	Result<o></o>
3<o></o>​	19933146<o></o>​	1/19/2013<o></o>​	<o></o>
4<o></o>​	36601355<o></o>​	1/28/2013<o></o>​	<o></o>
5<o></o>​	19933146<o></o>​	2/1/2013<o></o>​	<o></o>
6<o></o>​	19933146<o></o>​	2/2/2013<o></o>​	<o></o>
7<o></o>​	30012569<o></o>​	2/6/2013<o></o>​	median<o></o>
8<o></o>​	31258801<o></o>​	2/6/2013<o></o>​	median<o></o>
9<o></o>​	36601355<o></o>​	2/6/2013<o></o>​	median<o></o>
10<o></o>​	19933146<o></o>​	2/15/2013<o></o>​	median<o></o>
11<o></o>​	41677800<o></o>​	2/18/2013<o></o>​	median<o></o>
12<o></o>​	11250138<o></o>​	2/18/2013<o></o>​	median<o></o>
13<o></o>​	36601355<o></o>​	2/19/2013<o></o>​	median<o></o>
14<o></o>​	25141098<o></o>​	2/19/2013<o></o>​	median<o></o>
15<o></o>​	36601355<o></o>​	2/20/2013<o></o>​	<o></o>
16<o></o>​	36601355<o></o>​	2/26/2013<o></o>​	<o></o>
17<o></o>​	19933146<o></o>​	3/1/2013<o></o>​	<o></o>
18<o></o>​	19933146<o></o>​	3/4/2013<o></o>​	<o></o>
19<o></o>​	19933146<o></o>​	3/25/2013<o></o>​	<o></o>
20<o></o>​	36601355<o></o>​	3/28/2013<o></o>​	<o></o>

<TBODY>
</TBODY>