I have attached a small worksheet that explains my two problems.

My first problem. In one column I have various dates entered, in the
next column are numbers. What I need to be able to do is based on a
start and end date, I need to find all the data within the date range.

My second problem. I need to drop either 1,2, or 3 lowest scores
either based on all the data in each column (this is easy formula and
I've done that) or based on the date range.

Thanks for all help offered. I hope I have sufficiently explained my
problems.


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4124 |
+-------------------------------------------------------------------+

--
Frick
------------------------------------------------------------------------
Frick's Profile: http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493413