Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108137
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Logical based Horizontal Lookup |
| Date | 2015-10-28 20:51 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <n0r8rm$qim$1@dont-email.me> (permalink) |
| References | <f856d7a2-0a29-458f-968b-f96688885938@googlegroups.com> <n0r1hb$rjg$1@dont-email.me> |
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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Logical based Horizontal Lookup dvpetta@gmail.com - 2015-10-28 07:41 -0700
Re: Logical based Horizontal Lookup isabelle <i@v.invalid> - 2015-10-28 13:12 -0400
Re: Logical based Horizontal Lookup isabelle <i@v.invalid> - 2015-10-28 13:21 -0400
Re: Logical based Horizontal Lookup dvpetta@gmail.com - 2015-10-28 10:29 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2015-10-28 18:46 +0100
Re: Logical based Horizontal Lookup isabelle <i@v.invalid> - 2015-10-28 14:18 -0400
Re: Logical based Horizontal Lookup GS <gs@v.invalid> - 2015-10-28 14:39 -0400
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2015-10-28 21:23 +0100
Re: Logical based Horizontal Lookup GS <gs@v.invalid> - 2015-10-28 17:38 -0400
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2015-10-28 20:51 +0100
Re: Logical based Horizontal Lookup dvpetta@gmail.com - 2015-10-29 11:19 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2015-10-29 19:33 +0100
Re: Logical based Horizontal Lookup dvpetta@gmail.com - 2015-10-29 11:42 -0700
Re: Logical based Horizontal Lookup "Robert Crandal" <noreply2me@yahoo.com> - 2015-11-12 00:14 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2015-11-12 08:18 +0100
Re: Logical based Horizontal Lookup dvpetta@gmail.com - 2015-10-29 08:57 -0700
Re: Logical based Horizontal Lookup dvpetta@gmail.com - 2016-03-15 10:08 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-03-16 11:12 +0100
Re: Logical based Horizontal Lookup Daniel Petta <dvpetta@gmail.com> - 2016-03-16 04:44 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-03-16 13:12 +0100
Re: Logical based Horizontal Lookup Daniel Petta <dvpetta@gmail.com> - 2016-03-16 06:15 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-03-16 14:25 +0100
Re: Logical based Horizontal Lookup Daniel Petta <dvpetta@gmail.com> - 2016-03-31 09:56 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-03-31 19:45 +0200
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-03-31 20:11 +0200
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-03-31 20:12 +0200
Re: Logical based Horizontal Lookup Daniel Petta <dvpetta@gmail.com> - 2016-04-01 09:14 -0700
Re: Logical based Horizontal Lookup Daniel Petta <dvpetta@gmail.com> - 2016-04-12 04:22 -0700
Re: Logical based Horizontal Lookup Claus Busch <claus_busch@t-online.de> - 2016-04-12 14:18 +0200
csiph-web