Finding max and min in column

M

mikebres

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
 
P

Peo Sjoblom

How about using autofilter, filter on the planetcode, then use

=SUBTOTAL(4,range)

for MAX,

for MIN change 4 to 5
 
J

John Bundy

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
 
M

mikebres

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top