View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Davis S Davis is offline
external usenet poster
 
Posts: 138
Default Odd excel usage question:

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

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