Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have identifiers in the E column(101, 102, etc), and corresponding time
values in the J column. I need a formula in another cell that would give me the maximum time value of all the 101's, resuling in (0:17) And also in another cell the maximum value (0:43) of all the 102's. E col J col 101 0:00 101 101 0:17 101 102 0:11 102 0:00 102 0:01 102 102 0:43 102 0:00 102 0:01 102 0:03 102 0:00 Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
Preserving Cell References | Excel Discussion (Misc queries) | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |