Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chunrima
 
Posts: n/a
Default Make stair columns

Hi..there
If you have any clue, please help me out.
I have the values in A column below
A
B
C
D
E
F
G
H
I
J
K
L
But I wold like to get:
A
B D
C E G
F H J
I K
L

Thank you.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave R.
 
Posts: n/a
Default Make stair columns

The ouput you want is kind of garbled, looks like you want 3 rows in each
stair (where possible)?

What is this for?



"Chunrima" wrote in message
oups.com...
Hi..there
If you have any clue, please help me out.
I have the values in A column below
A
B
C
D
E
F
G
H
I
J
K
L
But I wold like to get:
A
B D
C E G
F H J
I K
L

Thank you.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chunrima
 
Posts: n/a
Default Make stair columns

This is more lined-up
A
B D
C E G
F H J
I K
L

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Make stair columns

You have a reply at your post in .misc.

Chunrima wrote:

Hi..there
If you have any clue, please help me out.
I have the values in A column below
A
B
C
D
E
F
G
H
I
J
K
L
But I wold like to get:
A
B D
C E G
F H J
I K
L

Thank you.


--

Dave Peterson
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
How do I make different size columns on the same work space? Marion Charts and Charting in Excel 1 August 6th 05 12:02 AM
How do I make the A,B,C... on top of the columns hidden? briana Excel Discussion (Misc queries) 2 July 26th 05 09:00 PM
Hiding columns and custom views problem Bettergains Excel Discussion (Misc queries) 2 April 12th 05 11:48 PM
When sorting info in columns, can I make it insert blank line bet. nanalehew Excel Worksheet Functions 2 March 12th 05 04:36 PM
Averaging columns rhodesv New Users to Excel 1 December 16th 04 08:14 PM


All times are GMT +1. The time now is 07:06 PM.

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

About Us

"It's about Microsoft Excel"