min/max

I generate a sheet every day that has 4 activities and associated data. I need to capture the MIN and MAX as part of the requirement. that is easy manually but how can you automate this every day to account for a different Activity range? In my example sheet, Activity 12 is rows 22 thru 25...

I am getting problem while generating a sheet Column AG (AG14-AG107) (Time) - 00:00, 00:15, 00:30, 00:45, 1:00, 1:15,.........., 23:45 Column AH (AH14-AH107) (Data) - 8, 8, 9, 40,......., 8 And need to show 'Min Time in AH112' and 'Max Time in AG114' As you see i need to get exact Min/Max Time...

hi, i have a data table as per the 15 min time for 24 hours. I have to show the min/max time as per the data. I tried every formula i knew but its not working. I have time in AG column and my data is in AH. =AH12=MIN(IF(TIMEVALUE(AG12)=TIMEVALUE(AG12:AG107),AH12:AH107)) currently I...

Hi everyone, How would I go about using min/max formulas with concatenated data? For example... I have two or more cells that are concatenated and I want to use min/max on formulas on them. There will be text as well as numerical values. "Owners" which would be text and and a "height" which...

I have a set of one-dimensional double arrays each containing thousands of members (geographic coordinates). Eg: Latitude = Array(20.356,22.369,23.568...) as Double || Longitude = Array(120.356,122.369,123.568...) as Double. When I loop through each array with WorksheetFunction.Min() /...

Hello, I hope someone can help me. How can I get the max/min dates from a table based on a person's data. For instance, I have the table as in the table below, where I am trying to get each person max and min date that they got paid. In red on the right are values that I typed based on the...