| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max Value from 2 different Ranges
Hey Tom thanks....but it isn't exactly working and I think it is because I
didn't explain it properly. Here are two lists and I want to get the Max(MaxHits) for each of the grp of dates: so the max value for 7/5 aND THE mAX value for 7/12 Date MAXHits 7/5/2003 12200 7/5/2003 132 7/5/2003 87 7/5/2003 501 7/5/2003 294 7/5/2003 24 7/5/2003 333 7/5/2003 61 7/5/2003 500 7/5/2003 163 7/5/2003 1022 7/12/03 8459 7/12/03 208 7/12/03 200 7/12/03 490 7/12/03 295 7/12/03 45 7/12/03 407 7/12/03 42 7/12/03 592 7/12/03 213 7/12/03 1538 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name Ranges | Excel Discussion (Misc queries) | |||
| how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
| Ranges | Excel Discussion (Misc queries) | |||
| Look up for a value in a s et of ranges | Excel Worksheet Functions | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
