Macro to display list of unique data from spreadsheet

Originally Posted by royUK

Use Advanced Filter -> unique records only

Thanks roy, that has helped me with the unique reg value. Any idea how i can acheive the second part?

PC