Challenging Problem
Hi Everyone,
I have the following data in columns A B C D
Vendor Name Invoice Date Invoice Number Employee Name
D & D 1/17/2002 3464043201
Flight,, William
D & D 1/17/2002 3464043201
Sunningham,, L Jean
D & D 1/17/2002 3464043201
Flight,, William
D & D 1/17/2002 3464043202
Barrar,, Netty R
D & D 1/17/2002 3464043202
Barrar,, Netty R
I want to look at column c (invoice number) then search thru column c
for each invoice number and compare it with column d. If there is more
than one name associated with each invoice number in column c I want
to indicate it with an x in new column e.
In the example above Flight,, William & Barrar,, Netty R will have
an a x in new column e
I would like a macro to do this as this spreadsheet has 5000 rows in
it
Thanks in advance for the groups guidance.
|