putting a number equal to writing commands

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Jason

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

Cheers
JulieD
 
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




.
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating the mean 2
if function 1
if function 3
sum of cells without #VALUE 2
A More efficient way to have a function with multiple SUMIF functions. 2
excel 2003 If function 4
Total Working hours If 2
If OR formula 1

Back
Top