Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ping Chip Pearson
I have a list of $ values in F4-F16 need to average the largest 5 amounts.
I copied this from Your website and made a slight mod to accommodate the 5 instead of 10 as on the site. ={AVERAGE(LARGE(F4:F16,ROW(INDIRECT("1:5"))))} I understand all but the (indirect("1:5)). I hate to be a bother but could you explain this part? What does the indirect function perform? Thanks lomax |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
Conditional Format Formula Needed | Excel Worksheet Functions | |||
PING: JulieD & AlfD re Sorting By Postcode | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Thank you Chip Pearson | Excel Discussion (Misc queries) |