If not an exact match to left of comma, then ALERT
 

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

If not an exact match to left of comma, then ALERT
 

Hi Steve

Insert this in F2 and copy down as required:

=IF(B2<LEFT(D2,FIND(",",D2)-1),"ALERT","")

Regards,
Per

"Steve" skrev i meddelelsen
...
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

If not an exact match to left of comma, then ALERT
 

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

If not an exact match to left of comma, then ALERT
 

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

If not an exact match to left of comma, then ALERT
 

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

If not an exact match to left of comma, then ALERT
 

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" skrev i meddelelsen
...
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

.

If not an exact match to left of comma, then ALERT
 

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" wrote in message
...
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