Req Formula to place 1 into next columns

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
 
P

Paul Corrado

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
 

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

Getting a formula to reflect added columns 10
Remove Identical words 0
Copy addition formula of non-consecutive horizontal cells 2
List all tables, including document structure 0
Merging from an Excel file with graphics 1
Display next available number 1
Arriving at totals 2
What is the "--" (double dash) in MS Excel formula? 2

Top