Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Help | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
An array formula to sum row max | Excel Discussion (Misc queries) |