Hello everyone,
I have only one column with a list shown as below for example:
There are a number of duplicate entries there. 2 Questions here:
a. How do I count the number of Unique entries and/or duplicates?
b. How do you display only the unique entries in the next column?
Thanks in advance for your help.
CANADIAN SPACE AGENCY
BANK OF CANADA
BELL CANADA
POWERSTREAM INC
ROYAL CANADIAN MINT
IMMIGRATION AND REFUGEE BOARD OF CANADA
CITIZENSHIP AND IMMIGRATION
AIR CANADA
CTC TRAIN CANADA 1075773 ONTARIO INC
HABITAT FOR HUMANITY CANADA
CANADIAN CENTRE FOR OHS-CCOHS OCCUPATIONAL HEALTH & SAFETY
DEPARTMENT OF FOREIGN AFFAIRS & INTERNATIONAL TRADE
CANADIAN SECURITY INTELLIGENCE SERVICE
MINISTER OF NATURAL RESOURCES CANADA
HEALTH CANADA
CANADIAN BANK NOTE COMPANY LTD
TREASURY BOARD OF CANADA (Hold off on this until Teresa confirms)
SERVICE CANADA
ELECTIONS CANADA
NATURAL RESOURCES CANADA HUMAN RESOURCES SECTOR MSD
MINISTRY OF NATURAL RESOURCES PROVINCIAL LOGISTICS CENTRE
DEPARTMENT OF JUSTICE CANADA NAT ACCOM OCC H & S DIVISION
IMMIGRATION AND REFUGEE BOARD OF CANADA
DEPARTMENT OF JUSTICE CANADA NAT ACCOM OCC H & S DIVISION
MINISTRY OF NATURAL RESOURCES FOREST FIRE MGMT CENTRE
NATIONAL RESEARCH COUNCIL CANADA (Hold off on this Until Teresa confirms)
NATIONAL GALLERY OF CANADA
NATIONAL GALLERY OF CANADA
MINISTRY OF NATURAL RESOURCES
CITIZENSHIP AND IMMIGRATION
ATOMIC ENERGY OF CANADA
NATIONAL RESEARCH COUNCIL CANADA
ONTARIO NORTHLAND TRANSPORTATION / ONTERA
PUBLIC SERVICE COMMISSION OF C ANADA
TELUS COMMUNICATIONS INC
NATIONAL ARTS CENTRE
NATURAL RESOURCES CANADA
HOUSE OF COMMONS
CANADA POST CORPORATION
NATIONAL CAPITAL COMMISSION
NATIONAL CAPITAL COMMISSION
HRSDC-LABOUR CANADA/RHDCC CANADA
CANADIAN GRAIN COMMISSION
Bookmarks