Dates Formula for lost costumers

[Nuno_Ric]

Hello All!

this formula is Killing me i really need your help!!!!



i have a list of Costumers, and need to know when was the last time they bought in my company,


I Have columns with data:

Costumer Name, Costumer ID, Sale Date, Sale ID



The idea is to get to the Buyers that dont buy nothing to my company in last 2 Years,

does Excel have a formula?

Thanks!

[AZ-XL]

I think Index-match combination withe a little modification will solve your problem. But without seeing your sample it will be difficult for us to say anything. Upload a sample file and desired result.

[Nuno_Ric]

This is a small example of my file. (more than 5000 reg.)

the idea is to know, how to identify who does not buy since 2012.

Thanks




Sale Date Sale ID State Costumer Name Costumer ID Count Number Sales
01-01-2014 Sold John 1 7
02-01-2014 Sold Patty 2 4
03-01-2014 Sold John 1 6
04-01-2014 Sold Sonia 3 3
10-01-2014 Sold Oxford 4 5
11-01-2014 Sold Oxford 4 4
12-01-2014 Sold John 1 5
01-12-2013 Sold Brady 5 1
02-12-2013 Sold Patty 2 3
03-12-2013 Sold Oxford 4 3
04-12-2013 Sold John 1 4
05-12-2013 Sold Sonia 3 2
01-11-2012 Sold Patty 2 2
02-11-2012 Sold John 1 3
03-11-2012 Sold Oxford 4 2
04-11-2012 Sold Patty 2 1
05-11-2012 Sold Oxford 4 1
01-10-2011 Sold Maty 6 4
02-10-2011 Sold Nile 7 1
03-10-2011 Sold Maty 6 3
04-10-2011 Sold Sonia 3 1
05-10-2011 Sold John 1 2
01-09-2010 Sold Maty 6 2
02-09-2010 Sold John 1 1
03-09-2010 Sold Maty 6 1
04-09-2010 Sold Raul 8 1

[Nuno_Ric]

here´s the sample file

[Nuno_Ric]

hello AZ-XL...can you help ?

[zbor]

Here:

Please Login or Register  to view this content.

(replace ; with , if you get error)

Edit: This will return you TRUE (buy) and FALSE (not buy since 2012)

[Nuno_Ric]

does it work in your Excel???
can you post the file where you work?

Thanks

[zbor]

Look here: