=MIN(IF((MOD(COLUMN(G291:M291),2)=1)*(G291:M291<0 ),G291:M291))

entered with ctrl + shift & enter

and it will only check every other cell, if the formula from the link works
then this will work as well

=MIN(IF(G291:M291<0,G291:M291))

also entered with ctrl + shift & enter, if you only want values greater than
zero change
< to



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"gezuvor" wrote in
message ...

The search feature on this site is rubbish, but Google found this...

http://www.excelforum.com//showthread.php?t=482399

Works perfectly. Thank you bpeltzer!


--
gezuvor
------------------------------------------------------------------------
gezuvor's Profile:
http://www.excelforum.com/member.php...o&userid=30383
View this thread: http://www.excelforum.com/showthread...hreadid=513898