December 2013 archive

Dec 30

Excel-Change the order in which you edit cells

Excel productivity Tweaks #1: Change the order in which you edit cells:   We all know that when you hit ENTER on a cell excel usually takes you to the next cell in that column for editing.  If you want to move to next cell while pressing enter.  Go to Tool-> Options->Advanced- > Editing Option..> …

Continue reading »

Dec 13

Excel Advanced Formula Tricks: Min ignore Zero for non-contiguous range

Sub: Min ignore Zero for non-contiguous range   Issue:         How to ignore zero in the min formula for a non-contiguous range ? Solution:   If the above solution is useful please leave your comment below.