Hi,
You could try this
=max(index((B2:B80=B83)*(C2:C80=C83)*(L2:L80),,1))
B2:B80 holds customers, C2:C80 holds product line and L2:L80 holds dates.
B83 has customer X, C83 has desired product line.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Nelson" wrote in message
...
I have 2 product lines each with 10 part numbers each
I pulled customers data and my profile sheet shows me what sub products of
the 2 main product lines the customer has purchased how much they
purchased
the part number and their renewal date
What I want to do now have a formula show me the max renewal date for
customer X for each major product line, I am assuming I would use
(ISNUMBER(MATCH(B8:B32,C47:C85,0))),L8:L32) but I am unsure how I would
include the find max date if (ISNUMBER(MATCH(B8:B32,C47:C85,0))),L8:L32)
is
met.
Any thoughs?
Thanks in advance
--
Nelson