Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creation of a table of n values
Hi all,
I have a small but anyway very interesting problem with Excel. I am actually starting from a table with some values inside. For example: 4 2 5 I am looking for a formula which would give me a new table like this: 4 4 4 4 2 2 5 5 5 5 5 I tried quite a few things, especially with the offset function, but couldn't set it. Your help would be greatly appreciated! Of course, I can't do it manually as my numbers look like 127,221 and not 4 or 5. Thank you, Johan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table creation in excel | Excel Worksheet Functions | |||
pivot table creation procedures | Excel Discussion (Misc queries) | |||
Excel summary table creation | Excel Discussion (Misc queries) | |||
Table creation help please | Excel Worksheet Functions | |||
Pivot Table Creation | Excel Programming |