Find records in Report that are not in Report 2 1

[MarkRobinson]

I've written this in MS Access VB, but don't know how to repeat it in excel 2000.
I've imported two reports into Excel
Sheet1 - All Customers (Cust Name in Col 1)
Sheet2 - This Years sales, by Customer (Cust Name in Col 1)

I need a list of all inactive customers based on cust name field.

How would I do this in Excel?

Thanks!

Mark C. Robinson
HandicappedPets.com

 

[SkipVought]

Hi,

faq68-5829

I'd use a query to return a QueryTable resultset containing the Not In criteria. No VBA required.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[xlbo]

or just a vlookup

=if(ISNA(Vlookup(A2,Sheet2!$A$1:$A$10000,1,false)),"Inactive","")

where your customer IDs are in colA, rows 2 to 10000

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question