Auto filling cells

[doublej41]

Hi All

I am trying to populate some of the cells in column B automatically, based on the value of cell A1. In column B I need to list the numbers 10 - 0, but I need to list each numbers on more than one row and I would like cell A1 to determine how many rows to fill.

For example, if in cell A1 I have the value 5, in column B I would like each number to be listed 5 times (10,10,10,10,10,9,9,9,9,9,8,8,8,8,8.....). If A1 = 2 then repeat each number twice (10,10,9,9,8,8...)

Is there a formula that could make this work?

Many Thanks,
Jonathan

 

[Akashwani]

Hi,

Take a look here at around 9m 40s......

http://www.youtube.com/user/ExcelIsFun#p/search/39/7le-m8YRP6M

I use this method to display the LAST X number of rows of data in a range. You should be able to use this method to do as you require.

I have a sample file here that does what Mike explains in the video....

doublej41.xls


Good luck and let us know how you get on.

Ak

 

[doublej41]

Hi Ak

Thanks again for your help. A few changes to the formula in the video and it is working as I need it to.

 

[SluggoP]

I am trying to populate a Yes or No choice function to a group of cells.
How do I do this?

 

[Akashwani]

Hi SluggoP,

Welcome to MrExcel.

First off I think that you need to start a new thread with your question.
Secondly, you need to provide a lot more information than you have done here.
You need to provide a sample of your data, explain what it is you want to do, and provide a sample of your expected results.

I look forward to reading your new post.

Ak