desoriente
New Member
- Joined
- Dec 31, 2010
- Messages
- 14
How do you get a maximum or minimum number based on two criteria (MAX or MIN if within date specified)?
DATE (Column A) ---- NUMBERS (Column B) ---- MAX OR MIN OF SPECIFIC DATE (Column C)
12/1/2010 -------- 30.00 ------ Maximum for 12/1/10 is: ?
12/1/2010 -------- 30.10 ------ Minimum for 12/1/10 is: ?
12/2/2010 -------- 29.99 ------ Maximum for 12/2/10 is: ?
12/2/2010 -------- 29.50 ------ Minimum for 12/2/10 is: ?
etc., etc.
Basically, I need a formula that produces a "Max" or "Min" for Column C, using the range of numbers in Column B AND only IF that range of numbers falls within a specific date in Column A, such as 12/1/10, 12/2/10, etc.
I can't get VLOOKUP, SUMPRODUCT, or DSUM to work. Any suggestions? By the way, I have Excel 2007. Thank you.
DATE (Column A) ---- NUMBERS (Column B) ---- MAX OR MIN OF SPECIFIC DATE (Column C)
12/1/2010 -------- 30.00 ------ Maximum for 12/1/10 is: ?
12/1/2010 -------- 30.10 ------ Minimum for 12/1/10 is: ?
12/2/2010 -------- 29.99 ------ Maximum for 12/2/10 is: ?
12/2/2010 -------- 29.50 ------ Minimum for 12/2/10 is: ?
etc., etc.
Basically, I need a formula that produces a "Max" or "Min" for Column C, using the range of numbers in Column B AND only IF that range of numbers falls within a specific date in Column A, such as 12/1/10, 12/2/10, etc.
I can't get VLOOKUP, SUMPRODUCT, or DSUM to work. Any suggestions? By the way, I have Excel 2007. Thank you.
