LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default Comparing Clients From Last Year to This Year

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert day of year to numeric value format year+day in 4 digits Kaaren Excel Worksheet Functions 3 February 7th 09 08:37 PM
Comparing YTD numbers between last year and present LilBeanie1033 Excel Worksheet Functions 1 December 9th 08 02:49 PM
IF statement comparing month and year separately spence Excel Worksheet Functions 6 April 26th 07 10:47 PM
Combination Graph with current year and prior year sales JanW Charts and Charting in Excel 2 April 5th 07 09:20 PM
how to calculate $1000/year at 5% for 25 years showing each year HELP! Setting up and Configuration of Excel 0 July 25th 06 12:58 AM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"