Posted to microsoft.public.excel.programming

external usenet poster

Posts: 17

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Offset a formula result	Patrick C. Simonds	Excel Worksheet Functions	1	August 16th 09 11:06 PM
indirect address offset in array formula	Tom	Excel Programming	3	January 29th 08 04:48 PM
Use of Offset function in array formula	scabHead	Excel Worksheet Functions	4	December 23rd 06 01:16 AM
Array Offset() formula with height of 1 returns duplicates?	Uhl	Excel Worksheet Functions	9	December 13th 06 01:22 AM
Select row (with offset) from VB formula result	RAP	Excel Programming	1	August 7th 05 09:22 AM

All times are GMT +1. The time now is 04:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us