CountIf Formula

[Redi]

Hi all
I posted this earlier:

Hi all,

here is the layout of my spreadsheet:


a3=apple
a4=orange
a5=pear


b2=red
c2=green
d2=yellow
e2=blue


b3=1
c4=1
d5=1
e5=1


f3=formula
f4=formula
f5=formula


g3=formula
g4=formula
f4=formula


column f formula: if there is a 1 on b3:e3, give me the color text
column g formula: if there is another 1 on b3:e3, give me the next
color text


thank you in advance!


And i got some good answers here:

http://groups.google.com/group/micr...31158986bf2/419bb05d1426bde7#419bb05d1426bde7

But, can someone help me with this other challenge?

can you help me with a formulate that can run into the consecutive
columns H, I, J, K, L and so forth, to find a third, fourth, fifth,
sixth, and so forth... 1.
Thanks in advance.


Thanks in advance!

 

[Lars-Åke Aspelin]

Hi all
I posted this earlier:

Hi all,

here is the layout of my spreadsheet:


a3=apple
a4=orange
a5=pear


b2=red
c2=green
d2=yellow
e2=blue


b3=1
c4=1
d5=1
e5=1


f3=formula
f4=formula
f5=formula


g3=formula
g4=formula
f4=formula


column f formula: if there is a 1 on b3:e3, give me the color text
column g formula: if there is another 1 on b3:e3, give me the next
color text


thank you in advance!


And i got some good answers here:

http://groups.google.com/group/micr...31158986bf2/419bb05d1426bde7#419bb05d1426bde7

But, can someone help me with this other challenge?

can you help me with a formulate that can run into the consecutive
columns H, I, J, K, L and so forth, to find a third, fourth, fifth,
sixth, and so forth... 1.
Thanks in advance.


Thanks in advance!

See the reply in the original thread.

Lars-Åke