I have a spreadsheet showing telephone numbers of people who have called the
fire brigade. I have used the "=countif" command to highlight those numbers
which appear more than once, (they appear in red). I need to be able to move
the duplicate numbers to a separate column but only show the duplicate number
once in that column. Any ideas?