Using Offset and Sorting

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have cells with the offset function within the formula - has saved me
linking a substantial amounts of cells that wern't going n the same
direction.

My problem is that I want to sort this data a certain way and I don't think
the offset can handle this

Anyway around the problem

Thanks
 
Hi Frank

I have 2 worksheets, sheet1=locations sheet2 = sales by week for those
locations

In Column D in sheet1 is listed the total sales for each location, this is
referenced to cell rows in sheet2. I used the offset function (via heply
from this newsgroup) to link just the first cell in sheet1 to sheet2 - then
I just copied that formula down

Now I want to sort sheet1 showing the best performing locations in
descending order

The long way is manually just link the cell with = then place the $ sign to
hold the absolute positions
 
Back
Top