| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
maximum value (for a calendar date)
I have the following data in my spreadsheet.
Col-A Col-B (Depth) 150 20/09/2008 00:00 155 20/09/2008 00:02 157 20/09/2008 00:04 ...... 350 15/04/2009 22:46 etc. I need to extract into a new column/table the maximum value of Col A per day. I have a number of spreadsheets of this data hence rather have a formula than do manually. Any help appreciated Many Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
| Maximum date in a Month | Excel Discussion (Misc queries) | |||
| How to link an Excel file due date to Outlook calendar date? | New Users to Excel | |||
| have a date cell pop up a monthly calendar to choose a date | Excel Worksheet Functions | |||
| how to convert julian date to regular calendar date | Excel Worksheet Functions | |||
Threaded Mode
