LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot activate smart tags - tried all the obvious sinclaira Excel Discussion (Misc queries) 0 March 12th 07 04:22 PM
A Really Stupid Obvious Question that is Driving Me Nuts Capt. Attitude Excel Discussion (Misc queries) 2 October 18th 06 06:23 PM
Not so obvious Chart? rvExcelNewTip Charts and Charting in Excel 4 June 1st 05 05:14 PM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"