Copy unique values

[Rob_010101]

Hello,

I'll try and keep this simple.

Sheet 1: Current 12 Months

In column B, I have a list of employee IDs. As this is an absence tracker, each separate occasion of absence for each employee is added as a new row (so the same employee could have multiple rows).

Sheet 2: Occasions Current 12 Months

In column B, I would like to use a function to copy only unique employee IDs from column B on the first sheet, so that each employee ID is only copied once.

I could do unique records with an advanced sort but would have to manually refresh each day. A formula will allow sheet 2 to auto-update when new data is added into sheet 1.

Appreciate the help.

Kind Regards
Chris

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Rob_010101]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

That's done, thanks

 

[Fluff]

Thanks for that.
How about

=UNIQUE(FILTER(Sheet1!B2:B1000,Sheet1!B2:B1000<>""))

 

[Rob_010101]

Thanks for that.
How about

=UNIQUE(FILTER(Sheet1!B2:B1000,Sheet1!B2:B1000<>""))

That's brilliant

Thanks

 

[Fluff]

Glad to help & thanks for the feedback.