Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table that looks like this:
Item 7/9 7/10 7/11 A 23 342 2323 B 343 219 643 Every day I add a new column with some additional data. Sometimes I add a new row for a new item. I would like a second table that will draw from the first table, and give me the values in the last two columns of the first table for each item. So it might look like this: Item Col1 Col 2 A 342 2323 B 219 643 Is there a formula I can use that will always pull the last two columns' worth of data for me? Thanks much, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CHOOSE from a column | Excel Discussion (Misc queries) | |||
How to indicate in formula to choose the entire column starting from a specified cell? | Excel Discussion (Misc queries) | |||
how i choose the column from a combo box | Excel Discussion (Misc queries) | |||
AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN. | Excel Programming | |||
choose more than 1 column | Excel Programming |