On Oct 29, 5:23 am, JE McGimpsey wrote:
One way:

=MIN(INDEX(INDIRECT("'Sheet1'!A:IV"),,COLUMN()))

So make In article
.com,



wrote:
Now, I am trying to drag the formula across IV cells using the + icon,
so that MIN(INDIRECT("'Sheet1'!A:A")) is for cell A1 and
MIN(INDIRECT("'Sheet1'!IV:IV")) is for cell IV1. The series is not
getting filled instead the formula is just copied. Anyway to fill the
series. Please let me know. Thanks- Hide quoted text -

- Show quoted text -

Excellent. Thank you