Selecting X cells based on answer to formula

R

refresh

Hi,

I am trying to put together a spreadsheet that performs a couple of tasks.
The first is basic resourcing which i am ok with, sort of how many heads and
how many hours available means X cases will be done.

The next thing I need to do is use the X cases result to identify from a
list the oldest date and work through sequentially X dates in that column,
which will not be consecutive, and tell me what the date of that case is. So
if there were 10 cases done I would like one cell saying the oldest case
worked on was - first date in column. And following doing the 10 cases I'd
like another cell to say that the date of the 10th case was ....

I'm confident that there ought to be a way to do this but I am having
difficulty getting there.

Any ideas please?

Thanks
 
Top