We distribute a local magazine and I store all data associated with it: product name
(how many months?), date ordered
of the subscription as well as the days left
till the subscription expires.
I have to contact all those customers whose subscription will end soon. In order to make this easy for me, I created a worksheet and used an advanced filter to copy all those customers whose subscription will end in 30 days or less. Some customers may already have bought a second subscription and thus don't need to show up on the filtered data. Please have a look at an example:
In this example, Simone has two subscriptions: One will end in less than 30 days and the other will expire in 155 days. (=she renewed her subscription). With the advanced filter, Simone's first subscription would show up. What do you suggest I do so that this first subscription doesn't show up?
I've attached an example to this post. It should be possible, shouldn't it? I am open/free to make changes to the worksheet.Thank you for your help and suggestions