Re: Wildcards

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

From: Roger Govier <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 20 Dec 2005 10:12:44 +0000

Hi

You can use something like =SUMPRODUCT(--(ISNUMBER(SEARCH("a*a",A1:A10)))) to find any sequence of the letters "a" and "a" with any character in between, anywhere within the cells.

Regards

Roger Govier

irresistible007 wrote:

Is it possible to use Wildcard characters in SumPorduct? here sumproduct
is supposed to act as alternate to conditional summing.

References:
- Wildcards
  - From: irresistible007

Prev by Date: Re: Vlookup accross multiple worksheets
Next by Date: Re: How to write the formula for time accounting for a work schedule
Previous by thread: Re: Wildcards
Next by thread: Re: How do I get rid of formulas?
Index(es):
- Date
- Thread

Relevant Pages

Re: Machines and people
... >Boolean Algebra lead to letters such as a,b,c,..etc. ... This standard specifies that 8 bits arranged in a certain sequence stand ... for the character 'A'; another sequence stands for the character 'a'. ... The basic answer to your question is that the bits get to be English ...
(Debian-User)
Re: My BLT
... letters in plaintext and watch BLT put them in ciphertext anyway. ... I came up with the following pools ... plaintext character. ...
(sci.crypt)
Re: Opera Quiz 2011 0206
... But the name of the character is ... different opera about a dozen years earlier. ... letters being 'left hand' or 'right hand' on the typewriter keyboard ... question was sung by this great singer -- for whom the following were ...
(rec.music.opera)
Re: Opera Quiz 2011 0206
... But the name of the character is ... different opera about a dozen years earlier. ... letters being 'left hand' or 'right hand' on the typewriter keyboard ... question was sung by this great singer -- for whom the following were ...
(rec.music.opera)
Re: Opera Quiz 2011 0206
... But the name of the character is ... different opera about a dozen years earlier. ... letters being 'left hand' or 'right hand' on the typewriter keyboard ... question was sung by this great singer -- for whom the following were ...
(rec.music.opera)