multiple looping criteria
 

I would like to try and loop the following formula through a set range
IF(AND(D$1=$B2,D$1<=$C2,$E$24=$AK$1,$AK2="X",$E$3 4$E$25),$E$24,"")

If the formula results True then the value in E24 is placed there.
want the formula to do this until cell E25 = 0.

Then I would like to move to the next cell in the range and use F24 a
the value returned and place that value until F25 = 0 and so on...

The range of cells that have the criteria is E25:P25, The correspondin
values that shopuld be returned are in E24:P24

I can't get it to work!

Thanks
Ji

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

multiple looping criteria
 

If these conditions are not met you want to display ""
D$1=$B2,D$1<=$C2,$AK2="X",

Then maybe something like this:

=IF(AND(D$1=$B2,D$1<=$C2,$AK2="X")=FALSE,"",INDEX ($A$24:$P$24,1,SMALL(IF(($
E$34$E$25:$P$25)*($E$24:$P$24=$AK$1)*($E$25:$P$25 <0),COLUMN($E$24:$P$25)),
1)))

Entered with ctrl+shift+enter rather than just enter. Probably not what you
want, but maybe it will give you some idea of how you can achieve your
desired result.

--
Regards,
Tom Ogilvy



"hotherps " wrote in message
...
I would like to try and loop the following formula through a set range:
IF(AND(D$1=$B2,D$1<=$C2,$E$24=$AK$1,$AK2="X",$E$3 4$E$25),$E$24,"")

If the formula results True then the value in E24 is placed there. I
want the formula to do this until cell E25 = 0.

Then I would like to move to the next cell in the range and use F24 as
the value returned and place that value until F25 = 0 and so on...

The range of cells that have the criteria is E25:P25, The corresponding
values that shopuld be returned are in E24:P24

I can't get it to work!

Thanks
Jim


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

multiple looping criteria
 

Thanks Tom, I'm going to sit down and give this a look. I've never eve
seen "Index" or "Small" before. I'll dig into it.

Thanks again
Ji

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