Retaining formula references after a sort

GimpBoy · May 14th, 2002, 03:55 PM

Hi, I'm working with a fairly large database, and in order to more easily get some formulas working I resorted the database based on some key values. The problem is, when I re-sort the database back to how it was before, all of the references in the formulas remain exactly the same, they don't track where the cells go. In my particular case, the cells end up changing rows, but the formula still points to the same old row and my results get all messed up.

I've tried variations on say, H3, $H3, H$3, and $h$3 but none of them work.

Any suggestions?

Chris Davison · May 14th, 2002, 05:30 PM

if possible, include the column with the formulae in the range that is sorted

if it's miles away, cut it and insert it appropriately

May 14th, 2002, 05:30 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	if possible, include the column with the formulae in the range that is sorted if it's miles away, cut it and insert it appropriately __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 03:55 PM	#1
GimpBoy New Member Join Date: May 2002 Posts: 1	Hi, I'm working with a fairly large database, and in order to more easily get some formulas working I resorted the database based on some key values. The problem is, when I re-sort the database back to how it was before, all of the references in the formulas remain exactly the same, they don't track where the cells go. In my particular case, the cells end up changing rows, but the formula still points to the same old row and my results get all messed up. I've tried variations on say, H3, $H3, H$3, and $h$3 but none of them work. Any suggestions?