Return Min & Cell address
Hi again,
Am Tue, 29 Jul 2014 09:27:53 +0200 schrieb Claus Busch:
=MIN(F2:G2)&" in "&ADDRESS(2,MATCH(MIN(F2:G2),A2:G2,0),4)
sorry, typo.
Try:
=MIN(F2:H2)&" in "&ADDRESS(2,MATCH(MIN(F2:H2),A2:H2,0),4)
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|