LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Making a Matrix into a column.......

I have what seems to be an easy problem which I am unable to solve....

I have a matrix, lets say

A B C D
E F G H
I J K L

and I want to extrat every 6th element reading from left to right, i.e. F, L
etc.....

Any ideas? I though I could put the matrix into a vertical series, i.e.
A
B
C
D
etc....
and then choose every 6th number but I can't even get that far!!!!

Thanks for any help....
 
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
Plot data from column to matrix Max Excel Discussion (Misc queries) 2 December 1st 06 01:08 AM
Plot data from column to matrix Torsbyn Excel Discussion (Misc queries) 0 November 29th 06 07:43 AM
Create a matrix from data in three column sa02000 Excel Discussion (Misc queries) 3 June 28th 06 02:25 AM
Matrix to single column RD Wirr Excel Worksheet Functions 13 January 4th 06 09:06 PM
Making a Bubble Chart based on n-values matrix Haydar Charts and Charting in Excel 1 August 8th 05 11:16 PM


All times are GMT +1. The time now is 11:18 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"