Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(array?) formula
Hi all,
In col E I have dates or text or nothing, in col G is ABC or RST or dates or text or nothing. and in col H numbers or something else. I need the (array?) formula that gives me the number in col H for which in col G is ABC or RST and in col E is the most recent date. Thanks in advance for your help and my best wishes for a goor 2006. Jack Sons The Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Suppress array formula #NA | Excel Worksheet Functions | |||
referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |