Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

How can i find the max value within a time range ased on two cells

Hi Rune,

Am Thu, 14 Nov 2013 08:33:52 +0000 schrieb RuneVSP:

Date Temp
1oct 10
2oct 10
3oct 12
4oct 10
5oct 14

B10=2oct
B11=4oct

try:
=MAX((A2:A6=B10)*(A2:A6<=B11)*(B2:B6))
and array-enter the formula with CTRL+Shift+Enter

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Simple code to find the empty cells in a range and cells with number	Subodh	Excel Programming	2	April 30th 10 06:05 AM
Find a range of values in a range of cells	Jack Taylor	Excel Worksheet Functions	20	November 25th 06 01:26 PM
Find next time in a range	Martin Wheeler	Excel Programming	8	March 1st 06 01:11 AM
find a cells from a range of cell	kelvintaycc	Excel Worksheet Functions	2	April 2nd 05 07:20 PM
Run-time error '91' on Cells.Find()	Vera	Excel Programming	0	January 20th 04 08:12 AM

All times are GMT +1. The time now is 05:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us