View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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:)
.