Perhaps this can help:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu200839


"Babymech" wrote:

I currently have an array formula that reads
{=IF(MilestoneDates=$D$31;Tasks;"")}

What this does is that it checks through my milestone dates and sees if they
are equal to the next Group Meeting date ($D$31) - if they are, the formula
returns the associated Task. The problem is I only know how to use this to
show the first such result. What I want to be able to do is return, for
example, all five tasks with this milestone date, on separate rows. The tasks
are all text values unfortunately, which means I can't use BIG or SMALL
unfortunately. Any ideas?