Help with a summary

K

Kristine

Hi all -
I hope I ask my question clearly..
I would like to make a summary of one spreadsheet on another in the same workbook. The problem is that I have weekly columns and I want the summary to reflect only the most current column, which is not an accumulated total of the previous weeks. Is there a way to: In Sheet1 ask Excel to "Show the furthest right column" from Sheet2? I tried to do a lookup function but it was getting far too messy and not really working the way that I had hoped

Any help is greatly appreciated
Thank you! Kristine
 
D

Don Guillett

the trick is to put in a number that is higher than what you are looking
for. This will find the last entry in row 1.
=INDEX(Sheet2!1:1,1,MATCH(99999999999,Sheet2!1:1))

--
Don Guillett
SalesAid Software
[email protected]
Kristine said:
Hi all -
I hope I ask my question clearly...
I would like to make a summary of one spreadsheet on another in the same
Click to expand...
workbook. The problem is that I have weekly columns and I want the summary
to reflect only the most current column, which is not an accumulated total
of the previous weeks. Is there a way to: In Sheet1 ask Excel to "Show the
furthest right column" from Sheet2? I tried to do a lookup function but it
was getting far too messy and not really working the way that I had hoped.
 
K

Kristine

Thanks, Dan, but I've just realized that I indicated that I wanted one column of information for my summary when I actually want four: Customer Locations AWR Prospect Locations Opportunit

In my data spreadsheet these four columns just repeat for each week. Can I do this function to grab the four furthest columns to the right rather than just one?
 
D

Don Guillett

You could use offset(,-3) for the first one -2, & -1

--
Don Guillett
SalesAid Software
[email protected]
Kristine said:
Thanks, Dan, but I've just realized that I indicated that I wanted one
Click to expand...
column of information for my summary when I actually want four: Customer
Locations AWR Prospect Locations Opportunity
In my data spreadsheet these four columns just repeat for each week. Can
Click to expand...
I do this function to grab the four furthest columns to the right rather
than just one?
 
Top