Comparing Clients From Last Year to This Year

Comparing Clients From Last Year to This Year

Post by TXVzdGFuZ » Tue, 15 Dec 2009 08:36:01


Hi,

I have had a look though the posts and not really found the answer I am
looking for...

I have data in Column A which lists clients that bought from us last year
(the client name could be repeated more than once).

I have data in Column B that lists clients (again these could be repeated
more than once).

I would like to see who were clients of ours last year that have not yet
signed up this year.

Hope someone can help.

Many thanks
 
 
 

Comparing Clients From Last Year to This Year

Post by Fred Smit » Tue, 15 Dec 2009 09:41:32

One option is Countif. In column C, use:
=Countif(A:A,B1)
and copy down.

You can then select the zeros in this column.

Regards,
Fred.

 
 
 

Comparing Clients From Last Year to This Year

Post by SkxhdGhhb » Tue, 15 Dec 2009 10:23:01

I'm assuming that column A hold's last year's list and column B holds current
signed-up list.

Select all cells with names in them in column A, use
Cells --> Conditional Formatting
and choose the "Formula is" option and enter a formula like this:
=COUNTIF(B:B,A2)=0
and then set up your format to highlight the names in the list in column A
that do not appear in column B. I chose simply to turn the background red.

NOTE: the formula above assumes that A2 is the cell with the first name in
it, change that to be the address of the first cell in the group you have
selected.
 
 
 

Comparing Clients From Last Year to This Year

Post by Herbert Se » Tue, 15 Dec 2009 11:53:46

Excel 2007 Advanced Filter
No helper column.
With Tables and Macro.
Creates sorted list of laggers.
http://www.yqcomputer.com/
 
 
 

Comparing Clients From Last Year to This Year

Post by TXVzdGFuZ » Fri, 18 Dec 2009 10:56:01

Thank you all for your suggestions, they work really well, thanks.