View Single Post
  #7   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

OkieViking wrote:
The cells I am looking at are all on one row, but every other column. How do
I make the below work?

[...]

=MIN(IF((MOD(ROW(A3:A8)-CELL("Row",A3:A8)+0,2)=0)*A3:A8,A3:A8))

which you need to confirm with control+shift+enter instead of the usual
enter.

Adjust the range to suit.