To understand the importance of the point I just made in the title and in the picture in this post, remember that although we are not going to use the customer name as a way of sorting, if they are not included in the sort area they will be detached from the fields- Bill no. and Bill amount.
Detaching one or more fields in the sorting process is the only reason how, for example, Nikki, who used to give only miss calls recieved Jennie’s Bill of Rs. 20,000 [Jennie used to be on the phone 24*7]
Put simply, if your worksheet contains 8 fields and 20 records, say , and even if you intend sorting those records only on the basis of one of those fields- all 20 records must be included in the range selected for sort.
So, pay a little more attention where you sort in Excel next time. This will make you customers happy 🙂
Happy learning 🙂