=G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8)
=G8=MIN($G$8,$K$8,$O$8,$S$8,$W$8,$AA$8)

Those formuls are correct. Select the cells from RIGHT to LEFT then try it.

--
Biff
Microsoft Excel MVP


"CE" wrote in message
...
Regarding Excel 2003, I want to indicate the min value in a non-contiguous
range of cells. The data are located in cells G8, K8, O8, S8, W8, AA8 and
each cell contains a formula. So far I've tried the following formulas but
without success.
1) =MIN(G8,K8,O8,S8,W8,AA8)
2) =G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8)
3) =G8=MIN($G$8,$K$8,$O$8,$S$8,$W$8,$AA$8)

Please help!