Formula needed

[bastiaan_vg]

Hi there,

I have two worksheets. In the first worksheet I have several records e.g.:
Column:
A .................... B
BCALIBRR ... 1
BCALIBRR ... 1
BCALIBRR ... 2
BCALIBRR ... 2
BCALIBRR ... 2
BGHALOO ... 1
BGHALOO ... 1
In the second worksheet I need to extract the unique records from the first worksheet.
I can do this using the advanced filter but is there a way using a formula in order that I get the unique records in the second worksheet:
Column:
A ..................... B
BCALIBRR ... 1
BCALIBRR ... 2
BGHALOO ... 1

Note: diregards the dots, they are there to outline the example
Thanks and best regards,
Bastiaan

[NBVC]

Welcome,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST