Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I know this is obvious but ..
I'm just not seeing it this morning!
I have 3 columns: Col P16 to P500 contains Project Names Col Q16 to Q500 contains Pricing Mechanism descriptions Col X16 to X500 contains Dates In Col AA16 - AA 500 I want to do the following: AA16 = Last Date for Project Name in P16:P500 where Q16:Q500 < "Fixed Price" I can do it with a sumproduct array but it (obviously) sums the dates where the project names and pricing mechs are the same. Many thanks for your help! -- "There are 10 types of people in this world. Those who understand Binary and those who don''t ..." |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot activate smart tags - tried all the obvious | Excel Discussion (Misc queries) | |||
A Really Stupid Obvious Question that is Driving Me Nuts | Excel Discussion (Misc queries) | |||
Not so obvious Chart? | Charts and Charting in Excel |