Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding max and min in column
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding max and min in column
How about using autofilter, filter on the planetcode, then use
=SUBTOTAL(4,range) for MAX, for MIN change 4 to 5 -- Regards, Peo Sjoblom "mikebres" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding max and min in column
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 -- -John Please rate when your question is answered to help us and others know what is helpful. "mikebres" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding max and min in column
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. "mikebres" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the LAST value in a column | Excel Worksheet Functions | |||
Finding the same value in another column | Excel Worksheet Functions | |||
Finding a number in a column out of an array in another column | Excel Discussion (Misc queries) | |||
Finding Info from Column A and Removing it from Column B | Excel Discussion (Misc queries) | |||
Finding the closest number in column A and take the value in column B | Excel Worksheet Functions |