Prev: Pictures won't go behind text in Excel.
Next: Possible Conditional Formatting
From: Steve on 8 Mar 2010 14:10
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: Per Jessen on 8 Mar 2010 14:25
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: Eva on 8 Mar 2010 14:26
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
From: Eva on 8 Mar 2010 14:29
Sorry, I forgot to change c with D
=IF(EXACT(B2,(MID(d2,1,SEARCH(",",d2)-1)))=TRUE,"","alert")

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"Eva" wrote:

> 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
From: Steve on 8 Mar 2010 14:47
Perfect. Thank you so much.

Steve

"Eva" wrote:

> Sorry, I forgot to change c with D
> =IF(EXACT(B2,(MID(d2,1,SEARCH(",",d2)-1)))=TRUE,"","alert")
>
> --
> Please click "yes" if this post helped you!
>
> Greatly appreciated
>
> Eva
>
>
> "Eva" wrote:
>
> > 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
 |  Next  |  Last
Pages: 1 2
Prev: Pictures won't go behind text in Excel.
Next: Possible Conditional Formatting