Multiple loops one result

H

hotherps

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
 
C

chris

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
 
H

hotherps

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
 
Top