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

.