Hello,

Problem I can't figure out:

In column A I have a list of "created on" dates for support cases in chronological order.
In column E I have a list of the "subject" the case was in regards to.

I am trying to devise a formula that will examine the dates in column A that match a given time period, and spit out the range of column E that corresponds with the records.

For instance, say im looking for the range of subjects that correspond to support cases opened in January 2010. The formula would need to determine the range of cells that meet those criteria, say it finds A2:A7, and then change the A's to E's, which would tell me the range of subjects of cases opened in Jan 2010, E2:E7.

This is part of a larger formula I'm trying to figure out to determine the most common support subject (the MODE of subjects I suppose you could call it) for a given time period...I'll spare the details of that until I can figure this out and tinker with the larger formula for a bit!!

Any help would be much appreciated!!