Thread: Excel 'Proper' Formula
View Single Post
Old 03-27-2005, 04:09 PM   #1
BarTopDancer
Prepping...
 
BarTopDancer's Avatar
 
Join Date: Jan 2005
Location: Here, there, everywhere
Posts: 11,405
BarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of cool
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
BarTopDancer is offline   Submit to Quotes Reply With Quote