Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a way for the columns in Excel to repeat. Let me explain. Pretend
the excel spreadsheet is a piece of paper. I would like to wrap that piece of paper around a cylinder so that if you turn it, the pattern repeats to infinity. I hope I have made this clear enough. A reply with answers or more questions would be greatly apreciated. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
As I understand you would like to get list which repeats in a column?
as it would be from monday to sunday and then again? so in this way you should create custom list Tools | Options | Custom list "Joel Reeves" <Joel wrote in message ... I need a way for the columns in Excel to repeat. Let me explain. Pretend the excel spreadsheet is a piece of paper. I would like to wrap that piece of paper around a cylinder so that if you turn it, the pattern repeats to infinity. I hope I have made this clear enough. A reply with answers or more questions would be greatly apreciated. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
An Excel worksheet is 2 dimensional with finite boundaries east/west and
north/south and cannot run to infinity. You can copy a column untill you run out of columns to copy to. Your description leaves this writer scratching his head. Do you want to try again? Gord Dibben MS Excel MVP On Tue, 8 Aug 2006 11:57:01 -0700, Joel Reeves <Joel wrote: I need a way for the columns in Excel to repeat. Let me explain. Pretend the excel spreadsheet is a piece of paper. I would like to wrap that piece of paper around a cylinder so that if you turn it, the pattern repeats to infinity. I hope I have made this clear enough. A reply with answers or more questions would be greatly apreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |