Hi All,

Here I am facing one challenge. I have a list of companies and there is near about 40,000 data. I have only two columns; one is Company names and other one is Sent Date

Now the problem is how can i judge the following?

* Have I sent any data for second times by date wise?
* If I sent any company for second times then how will I get the exact two dates?
* I want to work only for duplicate companies not for unique companies.


For example if i have the company names like

Cisco 06-25-11
Cisco 07-21-11

Like the above I do not how many duplicate companies are there in list and if I sent any data for the second time then how will I get it?

Please help!! I am in a tough situation...

I think I am capable enough to make you understandable what I exactly need..

Thanks in advance.

Niladri