I have a question in regards to sorting data on excel 2003.
What im trying to di is the following.
I created a report of our entire database of clients which is about 30 thousand records.
I also created a report from that database of clients who have purchased something from our company between the dates of september 2007 until today.
Now i want to merge the 2 reports crated, and remove the double entries, but i want to be left with clients who havent purchased anything.
If i use Data -> Filter ->Advanced Filter -> and Select unique records... will it remove both records? (the one from the report which has the total, and the one from the entire database report that has no total amount)
Basically, i want to be left with only those records that have not purchased anything.
Hope that's clear it's kind of tricky to explain lol...
Question
robertobaggio2k
Hi guys,
I have a question in regards to sorting data on excel 2003.
What im trying to di is the following.
I created a report of our entire database of clients which is about 30 thousand records.
I also created a report from that database of clients who have purchased something from our company between the dates of september 2007 until today.
Now i want to merge the 2 reports crated, and remove the double entries, but i want to be left with clients who havent purchased anything.
If i use Data -> Filter ->Advanced Filter -> and Select unique records... will it remove both records? (the one from the report which has the total, and the one from the entire database report that has no total amount)
Basically, i want to be left with only those records that have not purchased anything.
Hope that's clear it's kind of tricky to explain lol...
Thank you in advanced for your input!
Link to comment
Share on other sites
5 answers to this question
Recommended Posts