Populate Cells According to Numeric Response

[edrichard]

Hi,

I've been trying some different combinations of the IF function and can't come up with a way to do the following...

For example, if cell A1 has the number 3 entered in it, I'd like to populate cells B1,B2 and B3 with the text "True". In a nutshell, depending on the number entered in A1, I'd like to populate that number of cells in column B.

Perhaps I'm oversimplifying this and it's not even possible.

Any ideas, greatly appreciated.

[NBVC]

In B1: =IF(ROW()>$A$1,"",TRUE) copied down as far as you want

[VBA Noob]

Or with code.


Right click sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

VBA Noob

[NBVC]

From PM:

I tried the IF statement you sent me but it is not quite what I am looking to accomplish. When I enter any number in cell A1, it only places the text "True" in cell B1 and not the number of cells I entered in A1. So if I entered the number 2 in A1, the output should look something like...

2 True
True

See attached... you need to copy the formula down the column...

[edrichard]

Sorry, I missed something... When I wanted to add the text "True" to each of the cells in Column B, the field needed to be unique. I'd just like to append the number of results to "True" text. So if A1 is 2, then Cells B1 and B2 should be "True0" and "True1" and so on abd so forth, depending on the the number entered in A1.

Thanks.

[NBVC]

Change formula in B1 to:

=IF(ROW()>$A$1,"",TRUE&ROW()-1)

and copy it down.

[VBA Noob]

Code way

Please Login or Register  to view this content.

VBA Noob