Re: Range limited by a wildcard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 03/10/05 

Date: Wed, 9 Mar 2005 20:15:21 -0800

Are you saying that if there is an asterisk in B8, and another in B24, that
you want the max date in Column K from within the range of K8 to K24?

If that's so, how do the asterisks get there?
Do you key them in, or are they the results of other formulas? 

-- 
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:A6A0C44A-8E78-4703-A492-B8CBDBB4BDE0@microsoft.com...
> Hi RD,
>
> I apologize if I wasn't clear,. Here's an example:
>
> I need a formula that would evaluate the oldest dates in column K within 2
> wildcards located in column B.
> *
>
>
>
>
>
> Prov 2/28/2005
> Prov 1/31/2005
>
> *
>
>
> "RagDyeR" wrote:
>
> > When you say wildcard, I'm assuming B1 is start of date range (K10 or
> > whatever),
> > And B2 is end of date range (K11 or whatever).
> >
> > =MIN(DATEVALUE(SUBSTITUTE(INDIRECT(B1&":"&B2),".","/")))
> >
> > Although you didn't mention it, since it's your formula, you know that
it's
> > an *array* formula, but for the sake of other readers:
> >
> > Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of
the
> > regular <Enter>, which will *automatically* enclose the formula in curly
> > brackets, which *cannot* be done manually.
> >
> > -- 
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "Jeff" <Jeff@discussions.microsoft.com> wrote in message
> > news:BF701776-6656-4992-8665-F35F9D1E7229@microsoft.com...
> >
> > I need to run a formula that would do this on an active cell:
> > =MIN(DATEVALUE(SUBSTITUTE('408134.xls'!K10:K11,".","/")))
> >
> > But instead of delimiting the range from K10:K11, I would like the
formula
> > to evaluate the column K with a range defined within two wildcards *,
> > located
> > in column B.
> > The upper range would be *
> > The lower range would also be *
> >
> > This would be continuous, therefore the formula needs to go the next
range
> > delimited by two wildcards *
> > Regards,
> >
> >
> >

Relevant Pages

  • RE: Asterisk in VLOOKUP search
    ... of the asterisk because I actually need to find that asterisk. ... (I see the SUBSTITUTE function is binary search, not using wildcards.) ... Gary''s Student - gsnu200781 ... I'm using a column of data in a VLOOKUP search. ...
    (microsoft.public.excel.programming)
  • Re: IF Statement
    ... It doesn't work because the field does not accept wildcards. ... You can have an asterisk and more than one question ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.mailmerge.fields)
  • Re: how do I sort data that return name start with O to Sn?
    ... you're not concatenating the asterisk ... to the prompt, and wildcards only work with the LIKE operator, not the ...
    (microsoft.public.access.queries)
  • Re: How to find & replace a formula sequence with * in it?
    ... If you're looking to find or replace an asterisk, use ~* (tilde asterisk) in the ... An asterisk and questionmark represent wildcards. ...
    (microsoft.public.excel.misc)
  • RE: running a short perl script in a windows XP arena
    ... Windows XP does not allow the asterisk in paths or filenames. ... This is not a valid filename. ... wildcards, perl will not expand them automatically. ...
    (perl.beginners)