Re:Damn Excel – How the 'most important application' is ruin...
by james1071 on Sunday April 21, 2013 @04:56AM
(#5584349)
Spot that triangle among the million cells in a 1000 by 1000
table.
Re:Damn Excel – How the 'most important application' is ruin...
by jodrellblank on Sunday April 21, 2013 @10:59AM
(#5585028)
Click the "take me to possible formula errors" button.
http://www.c-sharpcorner.com/UploadFile/7e39ca/error-check-f...
It already does this, actually. Enter some data in two columns, like:
Then enter a sum formula in the next column like =SUM(A1:B1) and drag it all the way down. Change one in the middle to something else, like =SUM(B3:B3) instead of =SUM(A3:B3) and a little green arrow appears in the corner. Hover above it an it explains there is an "inconsistent formula".