stebrownsword
Board Regular
- Joined
- Apr 16, 2010
- Messages
- 151
Hey,
Help Please
how do you remove duplicates in excel in
Situation the spreadsheet is like
Coulmn A, employee personal numbers
Column B, employee name
Column C, Employee Job title
On my report if the employee has 2 jobs their name crops up twice, however i only want of their records to appear once.... so ideally i need excel to realise, this number already exists, remove row.
Thanks in advance
stephen
Help Please
how do you remove duplicates in excel in
Situation the spreadsheet is like
Coulmn A, employee personal numbers
Column B, employee name
Column C, Employee Job title
On my report if the employee has 2 jobs their name crops up twice, however i only want of their records to appear once.... so ideally i need excel to realise, this number already exists, remove row.
Thanks in advance
stephen