View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vlad[_8_] Vlad[_8_] is offline
external usenet poster
 
Posts: 17
Default Array Formula - Offset Result Problem

The following Array formula retulrns the maximum value in column E
where the value in Column H is Blue

{=MAX(($E$2:$E$115)*($H$2:$H$115="Blue"))}

How would I return the text in Column B for which is on the same line
as the maximum value in column E where the value in Column H is Blue

I'm using Excel 2003

TIA

A