Hi,

I am trying to use ADDRESS(B1-1,1,4,1) in a MIN function, the result
is and should be A307. The sub step I am looking for would be
MIN(ARC!A4:A307)

Such as MIN(ARC!A4:ADDRESS(B1-1,1,4,1))

but I get an error message. Any pointers on how I can make this work?

Thanks,
Joe