Req Formula to place 1 into next columns

  • Thread starter Thread starter stge
  • Start date Start date
S

stge

If I have the number 4 in column 'A' row 1, what formula do I need t
place a '1' into the next four columns (representing each of the 4 day
in column 'A'). I need to have a formula that would work from 0-9

Any help would be useful
Regards
stg
 
I think this may work for you

=IF(COLUMN(A1)<=$A1,1,"")

Put in B1 and copy across to column J and down as many rows as needed
 
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

Scrabble Value calculation for Welsh words 0
Excel VBA 1
What is the "--" (double dash) in MS Excel formula? 2
Sumproduct? 3
Excel Dragging countif formula with changing criteria 3
Count every group of numbers whose sum is zero & put formula next toeach number 7
Moving Column data formula 1
putting number against certain words formula 0

Back
Top