Lean Spreadsheets
Excel tips, tricks and effective ways to use professional spreadsheets
Pages
Home
Formula
Finance
Treasury
Business analysis
Visualise data
Power Pivot
Resources
Sunday, 14 October 2012
Calculate Smallest Number(s) - Excel
Type
=SMALL(
range
,
#
)
#
= #th smallest number in the range. E.G. to determine the 3rd smallest number enter
3
:
Type
=SMALL(
range
,
3
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment