Posts Tagged ‘ Functions ’

The Large and Small Functions in Microsoft Excel

April 11, 2012
By

Using the Large and Small Statistical Functions

It’s pretty straight-forward using the =Max() function to get the highest value in a range of cells or the =Min() function for the lowest value in a range of cells. But what if you need to get the 3rd largest or the 2nd lowest values in a range of cells? Read more »

Related Articles:

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2010-12-11 05:44:27. Republished by Blog Post Promoter

Random Numbers And The Randbetween Function

April 1, 2012
By

Generate numbers with the =randbetween function

Need to generate some test data to fill-in some rows and columns and not enough time to think up some random numbers? Read more »

Related Articles:

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2010-12-11 05:44:27. Republished by Blog Post Promoter

Archives

Tags

accounting format AutoAum AutoFill AutoFit Columns close Excel column border columns not wide enough Context menu copy cells currency format currency style cursor cut and paste cells date dates Drag and Drop edit Edit menu fill series format numbers formulas fractions Functions Keyboard shortcuts mouse pointer move sheet tab move worksheet normal view numbers open Excel page break view pound symbol print active worksheet print entire workbook print list print row and column headings print selection print titles randbetween random numbers save Excel set print area sum function the " # " symbol turn on gridlines