| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula - Offset Result Problem
why did my first suggestion not work?????
"Vlad" wrote: On Mar 1, 9:23 pm, JMB wrote: you would get an incorrect result if the data we 2 red 5 red 5 blue 4 green where another color happens to have a number that equals blues max and appears before blue in the list. Thanks for the suggestion but they don't work for me as it is quite likely that there would be duplicate items with the same max value. I thought something like {=MAX(($E$2:$E$115)*($H$2:$H$115=$J4)*($B$2:$B $115))} would work but it doesn't. Any other suggestions? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset a formula result | Excel Worksheet Functions | |||
| indirect address offset in array formula | Excel Programming | |||
| Use of Offset function in array formula | Excel Worksheet Functions | |||
| Array Offset() formula with height of 1 returns duplicates? | Excel Worksheet Functions | |||
| Select row (with offset) from VB formula result | Excel Programming | |||
Threaded Mode
