We distribute a local magazine and I store all data associated with it: product name (how many months?), date ordered, start and end 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 subscriptions.xlsm
sorry for my late reply
thanks a lot. the array formula works very well
massimo
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
=IF(C2=C3,H3,H2)