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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks