Forum Home
Press F1
Thread ID: 77773	2007-03-21 13:05:00	Excel data changing when sorted	vacon01 (12026)	Press F1

Post ID	Timestamp	Content	User
534957	2007-03-21 13:05:00	I have 2 columns of dates in my spreadsheet, column A and B. Column A is the next time we will be visiting a ship, and Column B is the last time we visited a ship. The ships have several entries each in the table. I have an = formulas set up so that the Column B dates are based on the previous line Column A dates. Example - Ship 1 has 3 lines (2, 3, 4) - Column 3B = Column 2A and Column 4B = Column 3A However, when I resort the data based on the dates we are visiting vice the ship, the data from the = formula is changing to the line above after the sort instead of remaining fixed to the original value. Example - Ship 1 line 3 is now line 20 - instead of the data in 3B being = to 2A, it is now = to 19A, which is a different ship than Ship 1 My question - Is there any way to fix the value so that when sorted, the dates will remain fixed to the original cel, vice the newly referenced cel after the sort? The dates in Column A change, and I really don't want to have to promogate the changes by hand through the spreadsheet.	vacon01 (12026)
534958	2007-03-22 01:23:00	Hi, see the INDIRECT formula. This points to a specific cell and may be what you require. Alternatively you may need to use another column with just the values posted (Copy then Edit|Paste Special - choose the values option). hth	Parry (5696)
1