Posted to microsoft.public.excel.programming

amyacc[_3_] amyacc[_3_] is offline

external usenet poster

Posts: 1

Excel Array Question

=INDEX('[Developmen
Update.xls]MASTER'!$I$6:$I$25,SMALL(IF(('[Developmen
Update.xls]MASTER'!$A$6:$A$25="X")*('[Developmen
Update.xls]MASTER'!$G$6:$G$25="Y"),ROW(6:25)),1))

Here's the formula. Again, the answer it's pulling does not only no
contain "Y", that cell in that row is blank. It's not the only cell i
that column that is blank. There really seems to be no reasonin
behind this.

THANKS

--
Message posted from http://www.ExcelForum.com

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
array question	Mona	Excel Discussion (Misc queries)	2	March 23rd 10 08:41 PM
array question	Len Case	Excel Worksheet Functions	3	December 17th 07 09:48 PM
Array question	Lee	Excel Programming	1	December 11th 03 08:01 PM
vba array question	chick-racer[_30_]	Excel Programming	4	November 10th 03 05:59 PM
Is this an array question?	Stuart[_5_]	Excel Programming	0	August 5th 03 08:53 PM

All times are GMT +1. The time now is 01:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us