Hi,

I have modified Richard Schollar's formula from the thread "Array formula that operates on non-adjacent cells"

http://www.excelforum.com/excel-work...ent-cells.html

My formula is

=MIN(IF(N(INDIRECT({"I8","Q8","W8","AC8","AD8","AK8","AL8","AM8","AU8","AV8","AW8","BE8","BF8","BG8","BO8","BP8","BX8","BY8","CF8","CG8","CH8"}))>0,N(INDIRECT({"I8","Q8","W8","AC8","AD8","AK8","AL8","AM8","AU8","AV8","AW8","BE8","BF8","BG8","BO8","BP8","BX8","BY8","CF8","CG8","CH8"})))) and is activated with Crtl + Shift + Enter.

This works great for the 8th row. However, when I drag to copy this down to other rows, it does not work. The formula remains the same (ie reffering to row 8).

How can I copy this formula to my other rows and have the corresponding min from the same columns?

Thanks