Logical based Horizontal Lookup
Hi again,
Am Wed, 28 Oct 2015 18:46:19 +0100 schrieb Claus Busch:
a little bit shorter and without array:
=TEXT((VERGLEICH("x";2:2;0)-3)/2/24;"hh:mm")&" - "&TEXT((VERGLEICH("";A2:AX2;-1)-2)/2/24;"hh:mm")
sorry, I forgot to translate the formula:
=TEXT((MATCH("x",2:2,0)-3)/2/24,"hh:mm")&" - "&TEXT((MATCH("",A2:AX2,-1)-2)/2/24,"hh:mm")
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|