Prev: Pictures won't go behind text in Excel.
Next: Possible Conditional Formatting
From: Steve on 8 Mar 2010 15:23
This one actually works even better, because it's not dependent on upper
case-lower case matches as the other one was.

Thank you,

Steve

"Per Jessen" wrote:

> Hi Steve
>
> Insert this in F2 and copy down as required:
>
> =IF(B2<>LEFT(D2,FIND(",",D2)-1),"ALERT","")
>
> Regards,
> Per
>
> "Steve" <Steve(a)discussions.microsoft.com> skrev i meddelelsen
> news:CBAC0CCB-57FA-4BAD-A4EF-9BA4FC28898C(a)microsoft.com...
> > I have two separate data columns. Col B has only last name, and Col D has
> > last name, comma, first name.
> >
> > I'd like ALERTs in the F column if everything to the left of the comma in
> > D2 Does Not Match exactly with B2, and dragged down. If it matches, then
> > nothing.
> > Something like this.
> > B D F
> > Montana Montana, Joe ""
> > Young Brady, Tom ALERT
> > Unitas Unitas, John ""
> > Bradshaw Young, Steve ALERT
> >
> > Thanks,
> >
> > Steve
>
> .
>
From: "David Biddulph" groups [at] on 8 Mar 2010 15:57
You don't need the =TRUE, because you've already got a Boolean.

=IF(EXACT(B2,(MID(C2,1,SEARCH(",",C2)-1))),"","alert")
--
David Biddulph


"Eva" <Eva(a)discussions.microsoft.com> wrote in message
news:3491B6F0-C5E2-4ABD-8709-1DE0C6A00B5B(a)microsoft.com...
> Hi Steve
> =IF(EXACT(B2,(MID(C2,1,SEARCH(",",C2)-1)))=TRUE,"","alert")
> --
> Please click "yes" if this post helped you!
>
> Greatly appreciated
>
> Eva
>
>
> "Steve" wrote:
>
>> I have two separate data columns. Col B has only last name, and Col D has
>> last name, comma, first name.
>>
>> I'd like ALERTs in the F column if everything to the left of the comma in
>> D2 Does Not Match exactly with B2, and dragged down. If it matches, then
>> nothing.
>> Something like this.
>> B D F
>> Montana Montana, Joe ""
>> Young Brady, Tom ALERT
>> Unitas Unitas, John ""
>> Bradshaw Young, Steve ALERT
>>
>> Thanks,
>>
>> Steve


First  |  Prev  | 
Pages: 1 2
Prev: Pictures won't go behind text in Excel.
Next: Possible Conditional Formatting