Hi guys
Firstly - thank you for all the help you've given me - I search the message board for answers regulary but I'm stuck on this one!
I have a spreadsheet filled with raw data of employees sick leave, unfortunately, the database this comes from records each period of sickleave under each department the employee has ever worked for, creating duplicates, so I need to compare the data in row B, columns A to G, with the data in row A, Columns A to G (and so forth...) and if it's a duplicate entry, either colour the cells using conditional formatting so i can de-dup manually or just delete the duplicates?
Column A = Contract Number
Column B = Surname
Column C = First Name
Column D = Absence Start
Column E = Absence End
Column F = No of Days
Column G = Reason for Absence
Column H = Department
Any help you can offer will be much appreciated!
Many thanks
Val
Firstly - thank you for all the help you've given me - I search the message board for answers regulary but I'm stuck on this one!
I have a spreadsheet filled with raw data of employees sick leave, unfortunately, the database this comes from records each period of sickleave under each department the employee has ever worked for, creating duplicates, so I need to compare the data in row B, columns A to G, with the data in row A, Columns A to G (and so forth...) and if it's a duplicate entry, either colour the cells using conditional formatting so i can de-dup manually or just delete the duplicates?
Column A = Contract Number
Column B = Surname
Column C = First Name
Column D = Absence Start
Column E = Absence End
Column F = No of Days
Column G = Reason for Absence
Column H = Department
Any help you can offer will be much appreciated!
Many thanks
Val