View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
[email protected] akrashid@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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.