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
--
asgh77
------------------------------------------------------------------------
asgh77's Profile:
http://www.excelforum.com/member.php...o&userid=36700
View this thread:
http://www.excelforum.com/showthread...hreadid=564707