Copying data from column F not A using my code

[strud]

I have data with a header in row 3 that spans from column A to I.

I have a formula which currently copies across data from column A and removes duplicates. I am trying to get it to copy from column F instead.

The code is:

Please Login or Register  to view this content.

I have changed it to:

Please Login or Register  to view this content.

But that still just copies column A

Any ideas anyone?

[nilem]

maybe

Please Login or Register  to view this content.

[strud]

Thanks nilem- I swear you've solved at least half of my problems on this forum lol!!