| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Max & keeping other data
I have a spreadsheet with three columns.
A: A date for every hour for the month (ie. 1/1/06 24 times) B: The hour C: A dollar amount I need to form a result that provides the max dollar amount per day, and I need to show the hour that it occurs on. I have no problem getting the max amount per day, but how do I also display the hour? Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| sorting (alphabetizing) while keeping data in tact. | Excel Discussion (Misc queries) | |||
| Keeping data in a cell stationary while the spreadsheet is scroll | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
