Duplicate Company Check by date

[niladri20052006]

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

 

[Robert Mika]

Hi Nilardi,
You can use this formula to check if the company is in your column A more than one:

=COUNTIF($A$2:$A$40000,A2)

or
=SUMPRODUCT(--($A$2:$A$40000=A2),--($B$2:$B$40000=B2))

copy down,filter by Column C


this to see if you got company and the same date more than once

 

[niladri20052006]

Hi Mike,

Thanks for your reply.

I need the second formula. But it is not working. I think it should be SUMPRODUCT(--(A2=$A$2:$A$39479),--(B2=$B$2:$B$39479))

However it is a too much time as there are 40,000+ data.

Is there any better way to solve that?

Thanks in advance

 

[Robert Mika]

I need the second formula. But it is not working. I think it should be SUMPRODUCT(--(A2=$A$2:$A$39479),--(B2=$B$2:$B$39479))

If taht works for you that's fine.


Could you post a bigger sample of your data?