Return Min & Cell address
Hi Howard,
Am Tue, 29 Jul 2014 00:18:53 -0700 (PDT) schrieb L. Howard:
Can this be done to return the MIN of F2, G2 or H2 and and "F", "G" or "H" which ever is the MIN?
Where F2=1, G2=2, F2=3.
try:
=MIN(F2:G2)&" in "&ADDRESS(2,MATCH(MIN(F2:G2),A2:G2,0),4)
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|