Hi Mahendhra

=ADDRESS(49,2+MATCH(MIN(C49:GL49),C49:GL49,0))
--
XL2003
Regards

William



"Mahendhra" wrote in message
...
I use the MIN(C49:GL49) function to get the minimum value contained in the
cell. Please tell me how to get the cell reference of the minimum value
rather than the value contained in the cell.

thanks
Mahendhra