How do I find the 12 highest numbers in a row of 52 numbers
Thanks guys, helped a lot
"Biff" wrote:
Hi!
Try one of these:
=SUM(LARGE(A1:AZ1,{1,2,3,4,5,6,7,8,9,10,11,12}))
Or, entered as an array using the key combination of CTRL,SHIFT,ENTER:
=SUM(LARGE(A1:AZ1,ROW(INDIRECT("1:12"))))
Biff
"johnny" wrote in message
...
How do I find the 12 highest numbers in a row of 52 numbers, add them
together and enter the total in a particular cell?
|