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

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

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 11:12 +0100
Organization A noiseless patient Spider
Message-ID <ncbbcm$h63$1@dont-email.me> (permalink)
References <f856d7a2-0a29-458f-968b-f96688885938@googlegroups.com> <5a625765-87d8-43f0-8f04-c34fb1d708ce@googlegroups.com>

Show all headers | View raw

Hi David,

Am Tue, 15 Mar 2016 10:08:03 -0700 (PDT) schrieb dvpetta@gmail.com:

> The key bit that I'd like to change is the MATCH section of the formula which essentially says when you find any character in this array begin the start of the shift.  This is done via "*" in MATCH.  
> 
> What I'd like to do is have MATCH not use "*" but only look for the following characters X, S, R, H, G, C, A, M, T, B.

try it with an UDF.
Please look here:
https://onedrive.live.com/redir?resid=9378aab6121822a3!326&authkey=!AApmk7UTBA7IuAM&ithint=folder%2cxlsm
for "schedule template" and download the file because macros are
disabled in OneDrive.


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