| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max function with conditional statment
Is there an equivilant of sumif for finding the maximum value. Given the
data below I would like to find the peak value for each time of each day. The highest number for Monday at 7, 8, etc. Day 7 AM 8 9 10 11 Mon 5 10 23 44 35 Tue 1 9 18 34 60 Wed 9 25 29 48 50 Mon 9 12 14 16 45 Tue 5 28 30 52 55 Wed 9 25 32 62 77 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function =IF statment limits | Excel Discussion (Misc queries) | |||
| Help with If statment | Excel Discussion (Misc queries) | |||
| If statment | Excel Discussion (Misc queries) | |||
| IF statment/function | Excel Discussion (Misc queries) | |||
| If statment | Excel Worksheet Functions | |||
Threaded Mode
