| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search in matrix.
Hi! I have a long list with three columns: Name, date and price. I also have
a matrix with dates as a column and names as rows. In every cell I have a value corresponding to that particular date and name. What I want to do is to get these values into my orginial list, ie I want to expand that list so that is has 4 columns. But how do I get the values from the matrix to the list? Any help appreciated! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search in matrix.
See:
http://www.cpearson.com/excel/lookups.htm -- Gary''s Student - gsnu200752 "Arne Hegefors" wrote: Hi! I have a long list with three columns: Name, date and price. I also have a matrix with dates as a column and names as rows. In every cell I have a value corresponding to that particular date and name. What I want to do is to get these values into my orginial list, ie I want to expand that list so that is has 4 columns. But how do I get the values from the matrix to the list? Any help appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
| How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
| Search lastname + firstname (search on uppercase) | Excel Programming | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Create a search Field within a worksheet to search command buttons | Excel Programming | |||
Linear Mode
