| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values across two columns with multiple conditions | Excel Worksheet Functions | |||
| Count Unique accross mulitple columns | Excel Worksheet Functions | |||
| count unique in one column based on two other columns | Excel Worksheet Functions | |||
| count unique instances based on two columns | Excel Worksheet Functions | |||
| Count unique if text | Excel Worksheet Functions | |||
Threaded Mode
