Function to seach a max value from ddmmyyhh

**Mohsin** · 12-13-2006, 11:55 PM

Hi there

Now i'm using a max(num1,num2) to seach a max value from ddmmyyhh, if i have more data, then is a bit slow,, due to manual clicking

it's anyother function to do same method?. I'm attached the sample of one data with date and value.

thanks

br, mohsin

**protonLeah** · 12-14-2006, 01:46 AM

A quick solution:
1. Insert a new column between the DATE & VALUE columns; call it DAY.
2. Enter the formula:

=LEFT(B2,8) "replace B2 with whichever column has the yyyymmddhh formatted date"

in the second row of the new column (C) and copy down (this will extract the date from your date-time value)
3. Select the entire Day and Value columns.
4. Menubar- Data>Subtotal:

For each change in: DAY
Use function: MAX
Add subtotal to: Value
Summary below data

**Mohsin** · 12-14-2006, 03:14 AM

Hi proton,

Thanks for the answer, Here i don't want to change the date format.
Objective here is to return the max value from one day. That's why i'm using max function to check the max value from the table.

br, mohsin

Function to seach a max value from ddmmyyhh

LinkBack

Thread Tools

Rate This Thread

Display

Function to seach a max value from ddmmyyhh

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions