Help! I have been asked by work to create a spreadsheet for tracking the number of companies we are speaking to. I need to calculate the total number of companies in a certain column but some companies are listed twice as we have different contacts in each company.

Do I need to somehow convert the text in to a numerical value in order to total each column and how do I go about excluding duplicates?

Thanks

Andy