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, 4 November 2012
Calculate Largest Number(s) - Excel
Type
=LARGE(
range
,
#
)
#
= #th largest number in the range. E.G to determine the 2nd largest number enter
2
:
Type
=large(
range
,
2
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment