Odd excel usage question:

S

S Davis

Hey there,

I would like to create a dynamic list from a table with shifting
values.

My data table:

Title1....0
Title2....2
Title3....1
Title4....3
From this data, is there anyway to derive a list that will look like
Click to expand...
the following:

Title2
Title2
Title3
Title4
Title4
Title4

.... in such a manner that as the values (0,2,1,3... etc) in the table
above change, the list will change with it?

Many huge thanks. I know this is most likely a bit of a stretch, but
its a design issue that I am trying to deal with and this is the most
effective way I see possible.

Thansk again
-Sean
 
M

MyVeryOwnSelf

I would like to create a dynamic list from a table with shifting
values.

My data table:

Title1....0
Title2....2
Title3....1
Title4....3

the following:

Title2
Title2
Title3
Title4
Title4
Title4

... in such a manner that as the values (0,2,1,3... etc) in the table
above change, the list will change with it?
Click to expand...

One way is suggested by the csv file below.

--------------------- cut here -----------------------
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",0,Title1,0
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B1+D1,Title2,2
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B2+D2,Title3,1
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B3+D3,Title4,3
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B4+D4,"=""""",
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
 

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

Conditional Chart 1
Excel 2003 - bar chart - data source question 0
Stumped on establishing web querries on MS Excel 9
question about the data type in excel 1
Long-winded question about limiting choices displayed in combo box 0
New shortcuts in Excel 2007 1
Get data from Access db and put in a formatted Excel spreadsheet 12
Reports in OLAP vs. Excel downloads 0

Top