LARGE with non-consecutive numbers

  • Thread starter Thread starter foilprint0
  • Start date Start date
F

foilprint0

Hi

I have 6 column of data in each column I have 10 section each with
rows the last row of each section has the data i need to find th
highest amount.

normaly i would use large and select all cells in the column but i nee
to miss out rows 1 & 2 then 4 & 5 then 7 & 8 and so on.

Can anyone help me with this?

Regard
 
Hi
try the following array formula (entered with CTRL+sHIFT+ENTER):
=LARGE(IF(MOD(ROW($A$1:$A$100),3)=0,$A$1:$A$100),1)

or array entered
=MAX(IF(MOD(ROW($A$1:$A$100),3)=0,$A$1:$A$100))
 
Let A2:A18 be the range of interest:

=MAX(IF(MOD(ROW($A$2:$A$18)-CELL("Row",$A$2)+1,3)=0,$A$2:$A$18))

which you need to confirm with control+shift+enter instead of just with
enter.
 
Back
Top