Problem with functions

  • Thread starter Thread starter anne
  • Start date Start date
A

anne

I have to combo list with dates , to choose date1 and
date2, wich are taken from column A , so from A1 to A...
we have dates (dynamic range)
In C1:I have a the possition of the date1 in the range
and in C2: the possition of the date2 in the range

Now in Column B I have diferents value according to the
dates , I need to have the min and Max of column B
according to the range choosen .

How can I obtain the min from the column B (the will min
change according we choose differents date in the list )

Anyone has any idea??

I am trying to use the function (DECALER and INDEX in
french)but It does not work ;o(

thanks
anne
 
Anne,

Just to make sure I follow you:

01-Jan-03 10 3 Dropdown with Jan 29
15-Jan-03 15 9 Dropdown with Apr 23
29-Jan-03 11
12-Feb-03 14
26-Feb-03 22
12-Mar-03 16
26-Mar-03 7
09-Apr-03 10
23-Apr-03 5
07-May-03 16
21-May-03 14
04-Jun-03 18

Now you want the Max and Min from Jan 23 to Apr 29 in col B

=MAX(INDIRECT("B" & C1 & ":B" & C2))
=MIN(INDIRECT("B" & C1 & ":B" & C2))

Dan E
 
Back
Top