Excel 'Proper' Formula

BarTopDancer · 03-27-2005, 04:09 PM

Is anyone familiar with the 'Proper' formula in Excel? I need to apply it to a spreadsheet that goes from A1:E22000 (no joke). I've worked on it and one of our IT guys worked on it and we both end up with the same circular reference. We've also tried inserting new columns, which work, however we can't have the duplicate columns (hiding them is a last resort) The data in the cells is unlikely to change, however there may be new cells added and cells deleted.

Any/all help is welcome. Thanks!

03-27-2005, 04:09 PM	#1
BarTopDancer Prepping... Join Date: Jan 2005 Location: Here, there, everywhere Posts: 11,405	Excel 'Proper' Formula Is anyone familiar with the 'Proper' formula in Excel? I need to apply it to a spreadsheet that goes from A1:E22000 (no joke). I've worked on it and one of our IT guys worked on it and we both end up with the same circular reference. We've also tried inserting new columns, which work, however we can't have the duplicate columns (hiding them is a last resort) The data in the cells is unlikely to change, however there may be new cells added and cells deleted. Any/all help is welcome. Thanks! __________________ Spork is the new MacGyver Postcards From My Edge
	Submit to Quotes