Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Odd excel usage question:
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? 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)" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
QUESTION: Copy pivottable from excel file to another. | Excel Discussion (Misc queries) | |||
MSQUERY...My Exact question (Excel 2000) | New Users to Excel | |||
Expanding memory usage Excel 2003 | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |