Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Computer program to autocheck for matches between files?

I am trying to find out if there is a program that I can input an excel spreadsheet, which contains a list of over 16,000 numbers from a debt collector that has placed many illegal calls to my cell phone, against a PDF file with my last 18 months of call history to match telephone numbers between the two from the spreadsheet and my phone bill? I could alternatively create a pdf file from the spreadsheet also if need be. I just don't want to take on the daunting task of manually searching the pdf file I do have of my phone bill for over 16,000 numbers. I don't care if it results in having to pay for the software to do it with.

2 Answers

Relevance
  • Anonymous
    11 months ago

    Copy the numbers from the pdf file and input them in the excel spread sheet in a different cell than the numbers that are already in the spreadsheet. Then use the COUNTIF formula to automatically check for matches all the way to the end of the list of 16,000 phone numbers. 

  • 11 months ago

    Your sentences make little sense.  I think what you're asking is if you can take the list of 16,000 numbers that you have on PDF and put it into excel.  I would go to my account on my phone provider's website and download the information.  You might have to do it in batches, but still pretty simple.

Still have questions? Get your answers by asking now.