View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Babymech Babymech is offline
external usenet poster
 
Posts: 49
Default nth value in an array formula

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?