Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108644

Re: Logical based Horizontal Lookup

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: Logical based Horizontal Lookup
Date 2016-03-16 13:12 +0100
Organization A noiseless patient Spider
Message-ID <ncbid3$bbe$1@dont-email.me> (permalink)
References <f856d7a2-0a29-458f-968b-f96688885938@googlegroups.com> <5a625765-87d8-43f0-8f04-c34fb1d708ce@googlegroups.com> <ncbbcm$h63$1@dont-email.me> <8be762b8-6220-4afd-871f-4e9340d31f14@googlegroups.com>

Show all headers | View raw

Hi Daniel,

Am Wed, 16 Mar 2016 04:44:59 -0700 (PDT) schrieb Daniel Petta:

> Is there any way to take the last part of the formula and have it use the same logic defined in the UDF?  

I put sTime and eTime in one UDF. Now you have to call the function in
the sheet with:
=myTime(C2:AX2)
Have a look:
https://onedrive.live.com/redir?resid=9378aab6121822a3!326&authkey=!AApmk7UTBA7IuAM&ithint=folder%2cxlsm
for "PLANNER 031616" and download the file.


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

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