Thread: Looking up data in a table
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
John Mc John Mc is offline
external usenet poster
  
Posts: 6
Default Looking up data in a table
Hi Group,

I found a solution to linearize a matrix of information in Excel.
See the following website:
http://www.cpearson.com/excel/MatrixToVector.aspx

The solution is to use the OFFSET function. Sweet solution.

-John
Reply With QuoteReply With Quote