View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Tannenbaum David Tannenbaum is offline
external usenet poster
 
Posts: 7
Default Formula to choose from the last column of a given row

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