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 ..."
|