multiple looping criteria

  • Thread starter Thread starter hotherps
  • Start date Start date
H

hotherps

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$34>$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
 
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.
 
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
 
Back
Top