Hi


Within my spreadsheet i have a column of data that changes in size every day. This column of data often includes repeated information that I dont need...

What i am looking for is a way to look at the column of data containing the duplicates and in another sheet paste the refined column...

So if you look below

personnel_id results required
test1 test1
test1 test2
test1 test3
test2 test4
test2 test5
test3 test6
test4
test4
test4
test4
test4
test5
test5
test6
test6
test6
test6


Any suggestions on how to achieve this would be great...


Thanks

Nuno