View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vitordf Vitordf is offline
external usenet poster
 
Posts: 10
Default Count Unique text in 3 different columns

Hi,

I saw a few formulas that adds Unique records when is numbers, but I have a
spreasheet which I need to count the Unique records (Names) taken into
consideration three diffrent columns, example;
Column A Column B Column C
DC&D aagis Ternure
DC&D aagis Ternure
DC&D adamk New Hire
DC&D adamk New Hire
DC&D adasilva New Hire
DC&D adasilva New Hire
DC&D vdafons Ternure
DC&D AMPATA Ternure
DC&D AMPATA Ternure
DC&D AMPATA Ternure
DC&D AMPATA Ternure
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO buyssp Ternure
AIO buyssp Ternure
AIO buyssp Ternure
AIO buyssp Ternure
AIO buyssp Ternure

Hope someone could help me.

Many Thanks,