Min formula non consecutive cells

[Bravo33]

I am trying to calculate the Min value of a non consecutive range of cells excluding 0 or Blanks

The cells I need to calculate are A4, A7, A10, A14, A18 (These are the Sum values of the intermediate colums which need to be ingnored.

So A1:A14 will not work.

Help appreciated

[alansidman]

With your formula open looking for criteria (cells to calculate on), click on A4, then holding down the control key, click on A7, then A10, etc.

[Dial1]

if the data set is that small you can just do a =min(a4,a7,a10,a14) but if it is a large data set this would be combersome. (essenially the same thing alan said)

[daddylonglegs]

Try this formula

=SMALL((A4,A7,A10,A14,A18),INDEX(FREQUENCY((A4,A7,A10,A14,A18),0),1)+1)

[Bravo33]

Daddylonglegs!!!

Cheers, works a treat.

I've on this for hours!!!!