title: Array Formula using Large Excel
body: <p>Im trying to calculate an array formula based on the top values, Say the top 20% and find the cut off</p>
  
  <p>At the moment my formula is similar to {=max(row(1:7)*--(sum(large(indirect(range),row(1:7))))
  
  <p>to find the maximum value that doesnt fit the formula, ie (1,2,3,0,0,0) then the max picks up the 3</p>
  
  <p>Can someone give me some pointers on where im going wrong ?</p>
  
  <p>Thanks</p>