Hi Rowan,

Thank you for your solution. As the values frequently change I've gone with
Aladin's Formulae solution.

Cheers,
Sam

Rowan wrote:
From the Data menu select Filter Advanced Filter. Select Copy to Another
Location. Select P1:P40 as the list Range. Enter E50 as Copy To Range. Check
Unique Records Only. Click OK.

Then select Range E50:E88 or whatever is last row and select Data Sort.

Hope this helds
Rowan

Hi All,

[quoted text clipped - 5 lines]
Thanks
Sam


--
Message posted via http://www.officekb.com