Thanks for the Rep. And to you also XOR LX
It's frankly astonishing how misunderstood is the use of entire column references within Excel formulas.
Usually done for convenience, ease, lack of awareness ... or just pure laziness As XOR LX has said, some functions are optimised and can cope with full column references but, once you get into home grown complex formulae, it can be deadly.
The other common mistake is to "prepare" empty rows with formulae such as I've seen workbooks wit tens of thousands of formula like that and, by removing them, it can reduce the size of the workbook by an order of magnitude.
Thanks Kyle: were there any replies to the cross post?
Bookmarks