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..> …
December 2013 archive
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.