Hi all,
To give you an overview of what i'm trying to achieve.
We have 280k of registered users (last 2 years regs) and we have a subset of 116k users that have opted into our marketing etc (this covers a longer time period). We have a massive service change and have a desire to tailor our messaging to each set.
I am trying to combine the 2 lists without duplication, whilst retaining some indication of those that were duplicates.
The majority of the 116k records are in the 280k records. So my thinking is:
As you can see, the overall aim of being able to identify who has opted in and who hasn't. just need to be able to have a combined data set which i can segment by marketing or no marketing with a filter.
The way the workbook is structured is CSV as follows: firstname, lastname, email address, dob, postal/zip code.
Sounds really easy but i have had no end of trouble with it... VBA macros not working, countif and more.
Last one i tried highlighted the duplicates but when i tried to filter, excel just hangs and i end up having to kill the process. Getting nowhere and i am running out of time to get the date uploaded to our email platform.
So please; any help or assistance you can provide would be appreciated.
Kind regards,
To give you an overview of what i'm trying to achieve.
We have 280k of registered users (last 2 years regs) and we have a subset of 116k users that have opted into our marketing etc (this covers a longer time period). We have a massive service change and have a desire to tailor our messaging to each set.
I am trying to combine the 2 lists without duplication, whilst retaining some indication of those that were duplicates.
The majority of the 116k records are in the 280k records. So my thinking is:
- That having them merged
- Duplicates removed
- Those that had a duplicate value are highlighted/identified in some way
As you can see, the overall aim of being able to identify who has opted in and who hasn't. just need to be able to have a combined data set which i can segment by marketing or no marketing with a filter.
The way the workbook is structured is CSV as follows: firstname, lastname, email address, dob, postal/zip code.
Sounds really easy but i have had no end of trouble with it... VBA macros not working, countif and more.
Last one i tried highlighted the duplicates but when i tried to filter, excel just hangs and i end up having to kill the process. Getting nowhere and i am running out of time to get the date uploaded to our email platform.
So please; any help or assistance you can provide would be appreciated.
Kind regards,
