| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Quick Explanation
=AVERAGE(LARGE(A1:A60,ROW(INDIRECT("1:10")))) This array formula averages the 10th largest values in the Range A1:A60, I understand it: so its taking the average value of LARGE(A1:A60,1), LARGE(A1:A60,2), LARGE(A1:A60,3).......... But how does ROW(INDIRECT("1:10") return the array 1,2,3,.... Thanks -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=469109 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quick way to add dollar signs to cell refs? | Excel Discussion (Misc queries) | |||
| Quick way to sort lists by text color? | Excel Discussion (Misc queries) | |||
| NEED HELP QUICK AGAIN! | Excel Discussion (Misc queries) | |||
| excel quick find format | Excel Worksheet Functions | |||
| quick books and excel 2002 | New Users to Excel | |||
Threaded Mode
