Tuesday, February 8, 2011

Large and Small Command in Excel

Many times we feel that commands can not be remembered when they are in numbers.  Therefore I am explaining one by one microsoft excel command which are required on day to day basis.
While viewing above picture, it can be observed that some numeric figures are lying in A column.   Commands are lying in D column and Result is available on C column.   Data in A column may be unsorted.  Large and Small command search data as per requirement of user.  These command are quit different from Maximum and Minimum commands.   Max and Min command can find only maximum or minimum.  Where as Large and Small command can search a series of data as available in above picture.  

Intense Debate Comments