LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formula Help klmiura Excel Worksheet Functions 2 February 11th 09 07:28 PM
Find specific value in array of array formula DzednConfsd Excel Worksheet Functions 2 January 13th 09 06:19 AM
meaning of : IF(Switch; Average(array A, array B); array A) DXAT Excel Worksheet Functions 1 October 24th 06 06:11 PM
Array Formula - using LEFT("text",4) in formula Andrew L via OfficeKB.com Excel Worksheet Functions 2 August 1st 05 02:36 PM
An array formula to sum row max ucamms Excel Discussion (Misc queries) 2 June 27th 05 08:54 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"