Multiple loops one result
I have a range of cells (D3:AJ19) that I would like to populate with
text value. It must qualify in three places. Range AK3:AP3 must be "X" Range (E34:J34) (E25:J25) Range B3:B19 D1:AJ1 I don't know how to run all three loops at once. I want to evaluate al three criteria before the value is placed in the original range. If i suceeds got to the nect cell, if it fails go down to the next row. Is this really that difficult? Thank -- Message posted from http://www.ExcelForum.com |
Multiple loops one result
i don't get it? what do you mean.. " Range (E34:J34) (E25:J25)" and "Range B3:B19 D1:AJ1
Do you mean the sum of the values in one range is the sum of the other, and if so don't you only have to test that once since it won't change. Please clarify what it is your testing for ----- hotherps wrote: ---- I have a range of cells (D3:AJ19) that I would like to populate with text value. It must qualify in three places. Range AK3:AP3 must be "X Range (E34:J34) (E25:J25 Range B3:B19 D1:AJ I don't know how to run all three loops at once. I want to evaluate al three criteria before the value is placed in the original range. If i suceeds got to the nect cell, if it fails go down to the next row Is this really that difficult Thank -- Message posted from http://www.ExcelForum.com |
Multiple loops one result
No, not the sum I was just illustrating the ranges.
If E34 E25 then go to the next cell F34 F25 etc. until Column J same idea for the other range. What I'm saying is that all three of the following would have to be true: AK3 = "x" E34 E25 B3 D1 and then the text value would appear. The part I'm having a problem explaining is that some ranges are horizontal and some are vertical. It should onnly test the cyle once and then loop to the next cell in the range of D3 AJ19. I don't know how to phrase all 3 loops at once. Thanks --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com