Re: Data Validation allow space

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

Bob,

thats a great solution, I will bear it in mind for future use and i
have changed most of my formulas to include it now.

I still wonder, does anyone know why it will allow a space in the list?
surely it should pop up as a disallowed value?

anyway, its working great now thanks to Bob.

Many thanks again

Duncan

(my formula now looks like
=SUMPRODUCT(--(LEFT(data!G2:G65536,3)="yes"),--(data!H2:H65536)) in
case it might be helpful to anyone)

.

Relevant Pages

  • Re: Stop the negativism!
    ... I think Wayne and Bob have missed the point: ... KNOW that your data may be skewed, and bear that in mind ...
    (borland.public.delphi.non-technical)
  • Re: Stop the negativism!
    ... I think Wayne and Bob have missed the point: so long as you KNOW that your ... you need to bear in mind ...
    (borland.public.delphi.non-technical)
  • Re: Joe the bastardi
    ... Bear in mind the OP has ridiculed someone's name. ... Thats what I object to, ... not that it is profane. ...
    (uk.sci.weather)
  • Re: Belkin FM transmitters UK
    ... Thats what I heard anyway. ... Bear in mind that anyone else close to your vehicle would be able to ... Nuisance to other vehicles puts me off, ...
    (uk.rec.camping)
  • Re: Red x where smile should be.
    ... Thank you Mr. Bear. ... Just Bob wrote: ... One more if you don't mind. ... This box I uncheck somehow is getting ...
    (microsoft.public.windowsxp.newusers)