putting a number equal to writing commands
 

Hello!

How can i put a certain number to write as many "x"-s (for instance) to a
certain number of places.
For more clarity, pleasee see http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)

Place this in A3, copy across as far as needed, then copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)=1) ,"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.

Hi Jason

it works better if it's put in C3 rather than A3:)

Cheers
JulieD

"Jason Morin" wrote in message
...
Place this in A3, copy across as far as needed, then copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)=1) ,"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.

Doh! Did I write A3? Thanks Julie.

Jason

-----Original Message-----
Hi Jason

it works better if it's put in C3 rather than A3:)

Cheers
JulieD

"Jason Morin" wrote
in message
...
Place this in A3, copy across as far as needed, then
copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)
=1),"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.



.

I should have written "Place this in C3". Sorry.

Jason

-----Original Message-----
Place this in A3, copy across as far as needed, then
copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)
=1),"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.

.

I'm sorry, it gives me a false message
http://www.hot.ee/rekor/hmm.GIF


"JulieD" wrote:

Hi Jason

it works better if it's put in C3 rather than A3:)

Cheers
JulieD

"Jason Morin" wrote in message
...
Place this in A3, copy across as far as needed, then copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)=1) ,"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.

I'm sorry, but I still haven't got it right.

It gives me the same error message as i wrote before.
http://www.hot.ee/rekor/hmm.GIF

Please help!

"Jason Morin" wrote:

I should have written "Place this in C3". Sorry.

Jason

-----Original Message-----
Place this in A3, copy across as far as needed, then
copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)
=1),"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.

.

Hi Martin

can't see what is wrong - if you'ld like to email me direct i'll send you a
worksheet with the formula in it then we can see how that works on your
system. My email address is julied_ng at hcts dot net dot au.

Cheers
JulieD

"martin" wrote in message
...
I'm sorry, but I still haven't got it right.

It gives me the same error message as i wrote before.
http://www.hot.ee/rekor/hmm.GIF

Please help!

"Jason Morin" wrote:

I should have written "Place this in C3". Sorry.

Jason

-----Original Message-----
Place this in A3, copy across as far as needed, then
copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)
=1),"x","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello!

How can i put a certain number to write as many "x"-s
(for instance) to a
certain number of places.
For more clarity, pleasee see
http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this
number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
.

.