Easy for the experts: Lookup,index,match....
Harlan:
That did the trick. Perfect...
Now, if I wanted to search sheet one (pH Readings) for all 09/01/06 values,
find the min and max and place the answer in sheet two (Min-Max) - DATE ,
MIN, MAX and then continue through all the dates available - could I not use
a lookup, or an Index/Match function ?
Take ca
ddd
"Harlan Grove" wrote:
DDD wrote...
....
The input data is not finite and varies day to day month to month. What I
Maybe your data isn't 'finite' theoretically, but you can only fit a
finite amount into any Excel worksheet. Perhaps you mean it could fill
an entire column from row 2 down to row 65536. I'll assume that's what
you meant.
was looking for was how to search all of the 09/01/06 entries (between 300
and 1000 entries) for a max and min, then write that date and it's
corresponding min/max values - then continue to the next date in the data
09/02/06 and search all that date for min/max - write that date and the
min/max --- continue until the data runs out about 10K to 13K entries per
month... Does that make sense?
....
"Teethless mama" wrote:
B2 =MIN(IF(Sheet1!$A$2:$A$5=Sheet2!$A2,Sheet1!$C$2:$C $5))
C2 =MAX(IF(Sheet1!$A$2:$A$5=Sheet2!$A2,Sheet1!$C$2:$C $5))
You could use the suggested approach, just adjust the range references,
e.g.,
B2:
=MIN(IF(Sheet1!$A$2:$A$65536=$A2,Sheet1!$C$2:$C$65 536))
and similarly for the MAX in C2.
Adjust the range references in the formulas above as needed. Since you
haven't specified *YOUR* actual ranges or worksheet names, that task is
left to YOU unless you provide those additional details.
|