Auto-size list question

Evripos

New Member
Joined
Mar 3, 2011
Messages
13
Hi.
I have a columnar list which I would like to make it dynamic based on a number I input. So, if I have let's say the following columnar list how can I make it become shorter or longer based solely on my numerical input?
Input n=10
Car1
Car2
Car3
Car4
Car5
Car6
Car7
Car8
Car9
Car10



<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Thank you.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

BlueHornet

Active Member
Joined
Apr 13, 2012
Messages
338
The simplest way that I can imagine is by using a Table. In the table you create, your numerical entry would be in one column (I used Column A:A), and another column would have the formula: ="Car" & A2 (or whatever). Since it's a Table, the formula at B2 would be repeated row-by-row as entries are made below A2.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,823
Hi

Write in column A the list with the maximum number of elements that you need.
Write in B1 how many you want

Define the name:

Name: CarList
RefersTo: =OFFSET(A1,0,0,B1)

CarList will be your dynamic list.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,902
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top