Find lowest number greater than 0 but not in a range

I have an excel sheet I am looking to find the lowest number in the cells in a column that is not a range. These are monetary values as well, I have formatted the cells as currency. For instance, I do not have A1:AZ1

I have G7,J7,M7,P7,S7,V7,Y7,AB7,AE7,AH7

now I have done some searching and it is either SMALL or MIN. Here are the formulas i am trying, but getting #value as my return even though they are all marked as currency.

Please Login or Register  to view this content.

I am not understanding something here. Thank you for your help.

This is a range.

Formula:

Please Login or Register  to view this content.

Not a contiguous range but still a range.

Plus there's a pattern, I think, of every third column.

array entered
=SMALL((MOD(COLUMN(G7:AH7),3)=1)*(G7:AH7),19+SUMPRODUCT(--(MOD(COLUMN(G7:AH7),3)=1),--(G7:AH7=0)))
but there must be shorter

Not much shorter but a little simpler (and no "array entry")

=SMALL((G7,J7,M7,P7,S7,V7,Y7,AB7,AE7,AH7),INDEX(FREQUENCY((G7,J7,M7,P7,S7,V7,Y7,AB7,AE7,AH7),0),1)+1)

or an array

=MIN(IF(G7:AH7>0,IF(MOD(COLUMN(G7:AH7)-COLUMN(G7),3)=0,G7:AH7)))

confirmed with CTRL+SHIFT+ENTER

I don't know what is between the mentioned cells but this should work:

Formula:

Please Login or Register  to view this content.

Enter with Ctrl+Shift + Enter.

jdykstra

Any chance you could attach a file?

That should give us a clearer idea of what you are trying to do.