I am fairly new to Excel. Lately have been using a sumproduct formula to compare rows and colums to find duplicate records for genealogy, Name, Date of Birth, Date of Death, however if the text is in all CAPS or Mixed, this formula does not seem to pick out the fact it is the same. Is there any way to cope with this problem? or do i need to paste the column into word and use the change case button to convert all to upper or lower case and then paste back to excel? Any help will be appreciated.