Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOPING multiple ranges | Excel Discussion (Misc queries) | |||
Macro for Looping for Criteria Checking | Excel Discussion (Misc queries) | |||
Looping through multiple controls | Excel Programming | |||
Macro bug - looping thru multiple worksheets - workaround? | Excel Programming | |||
looping to create multiple files | Excel Programming |