Prev: How do I compare two columns contents for differences
Next: Need to separate and rearrange names
From: Gord Dibben on 1 Apr 2010 16:01
Did you copy down to A10000 as Per suggested?


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 12:39:21 -0700 (PDT), Pierre <cowguy(a)aol.com> wrote:

>Per, can it be adjusted to find a "Yes", or "No", if the value is
>found (or not found) within all the cells in the entire column, not
>just the range in A1? Lets say A2:A10000?
>I tried replacing it with that and it didn't behave.
>
>Thanks for your thoughts on this.
>
>Pierre
>On Apr 1, 1:56�pm, Per Jessen <perjesse...(a)hotmail.com> wrote:
>> Hi
>>
>> This formula will return Yes if the number in B1 is in the range given
>> in A1.
>>
>> =IF($B$1>=LEFT(A1,FIND("-",A1)-1)*1,IF($B
>> $1<=MID(A1,FIND("-",A1)+1,999)*1,"Yes","No"))
>>
>> The formula can be copied down as required.
>>
>> Hopes this helps.
>> ...
>> Per
>>
>> On 1 Apr., 20:16, Pierre <cow...(a)aol.com> wrote:
>>
>>
>>
>> > In one column (b), have the figure of 470
>> > In another column (a), a cell contains values containing a number, a
>> > dash and another number: "425 - 490"
>> > I need to check to determine if the number 470 is found within a range
>> > defined by a cells contents. �In this case, yes, it's equal to or
>> > between them.
>>
>> > (The dash may or may not have spaces around it. �..could be 425-490,
>> > or 425 - 490.)
>> > The column (b) item can be the 425, or the 490 and any number in
>> > between.
>>
>> > Need to do a vlookup to find if the 470 is present in any of the
>> > assorted ranges contained in column (a).
>>
>> > Thanks for your interest.
>> > Pierre- Hide quoted text -
>>
>> - Show quoted text -

 | 
Pages: 1
Prev: How do I compare two columns contents for differences
Next: Need to separate and rearrange names