Forum Discussion
Lookup Issue
I have a workbook with different worksheets for each stock that I own that keeps a daily record of the price to show how it does each day of the year. At the bottom of each sheet is a formula that ta...
Is there a reason for not updating to the 2007 technology of Tables?
{OK, even considering such things proves that I am not a dyed-in-the-wool spreadsheet buff!]
The existing formulas with INDIRECT and whole column references caused my computer (a core17, 64 bit, Surface laptop) become sluggish (a second or so delay following any change) even on such a trivial dataset.