tag customers for marketing
I want to tag customers in a prospect list from a current customer list
so I don't send advertising to current customers only prospect |
tag customers for marketing
Put in a formula in an adjacent cell the tags the customers
if F2 as an example =if(D2<DateSerial(Year(Today())-1,Month(Today()),1),"Send To","Don't Send To") Then drag fill down the column for as long as you have data. Obviously the condition of checking the date in Column D against a date a year prior to today is notional and would be replaced with the conditions that identify the data in a row as a current customer. -- Regards, Tom Ogilvy "Dave" wrote in message ... I want to tag customers in a prospect list from a current customer list so I don't send advertising to current customers only prospect |
tag customers for marketing
"Tom Ogilvy" wrote: Put in a formula in an adjacent cell the tags the customers if F2 as an example =if(D2<DateSerial(Year(Today())-1,Month(Today()),1),"Send To","Don't Send To") Then drag fill down the column for as long as you have data. Obviously the condition of checking the date in Column D against a date a year prior to today is notional and would be replaced with the conditions that identify the data in a row as a current customer. -- Regards, Tom Ogilvy "Dave" wrote in message ... I want to tag customers in a prospect list from a current customer list so I don't send advertising to current customers only prospect Thanks for responding But there are no dates invoulved I have a worksheet of current customers and a worksheet of prospect. I want to lookup my current list and compair to prospect so I don't do a mailer to current customers I don't know if or how to do a lookup function for characters Thanks Dave |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com