Finding max and min in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help finding the max and the min values in a column using a value
from another column. This is just a piece of the data, but the parts for
this question look like this:
Scan Date Time Planetcode
07-10-2007 13:50 4099830901802
07-11-2007 01:30 4099830901802
07-11-2007 03:42 4099830901802

The data comes from a larger web based database where all the fields are
exported as text. I have already filtered out the char(160).
I have a list of Planetcodes that I want to match against the full list and
get the max(Scan Date Time) and min(Scan Date Time) for each Planetcode.
I was thinking an array formula would work, but I guess I don't understand
them well enough to makes it work for this.

Does anybody have a solution?
Thanks
Mike
 
How about using autofilter, filter on the planetcode, then use

=SUBTOTAL(4,range)

for MAX,

for MIN change 4 to 5
 
You can utilize subtotals, for each change in planet code Min Time
Then do it again with max make sure you uncheck the replace values box
 
Thanks all for the suggestions. I finally got the array formula to work. In
case anybody finds it useful here is what I came up with:

={MAX(IF(Planetcode=E4,SDT))}

It's simple once you see it.
 
Back
Top