Hi all, i have just given a solution to an Ops who asked how do they calculate the top 7 figures in a row of 10, my solution was an array formula [VBA]{=SUM(LARGE(A3:L3,{1,2,3,4,5,6,7}))}[/VBA], what i would like to know is, are there any limitations to this formula?, does it only work on contiguous data? can it work over many rows?, does a blank count as a figure in this kind of formula? if any of the above have a negative effect is there a way to combat them?
Regards,
Simon