Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Repeating Columns

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Repeating Columns

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Repeating Columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 2 July 31st 06 09:45 PM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 0 July 31st 06 05:07 PM
Merging two columns and keeping the data from both Stosh Excel Worksheet Functions 9 July 27th 06 06:48 PM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"