It's different than volatile because it doesn't recalculate in reponse to changes on other sheets, and it doesn't recalculate if you press F9.
Your solution is good unless someone moves all of col B.
It's different than volatile because it doesn't recalculate in reponse to changes on other sheets, and it doesn't recalculate if you press F9.
Your solution is good unless someone moves all of col B.
Last edited by shg; 04-21-2012 at 01:29 PM.
Entia non sunt multiplicanda sine necessitate
Why would it be a problem if the entire column is moved?
When I'm working on the file I move entire columns, but the owner only moves what he can see.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks