You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Quovardis via OfficeKB.com" <u38145@uwe wrote in message
news:7990723733ae4@uwe...
Dude...your a genius.

It works perfectly....thank you sooo much



T. Valko wrote:
One way...

Enter the date of interest in cell A1.

Assume your data is in the range B2:B110 and K2:K100.

Enter this array formula** in cell A2 and copy down until you get blanks:

=IF(ROWS(A$2:A2)<=COUNTIF(K$2:K$100,A$1),INDEX(B $2:B$100,SMALL(IF(K$2:K$100=A$1,ROW(B$2:B$100)-MIN(ROW(B$2))+1),ROWS(B$2:B2))),"")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

The other big problem comes because the data comes
from an updatable DB and when I extract the data i dont
know exactly how many matching dates im going to have.

You'd have to rely on past knowledge. For example, if you know the most
matching dates that there has ever been is say, 30, then you have to copy
the formula to at least 30 cells.

Hi,

[quoted text clipped - 30 lines]

I hope someone can help with this as I cant find anything that helps.

--
Message posted via http://www.officekb.com