Selecting only rows of data with unique identifier
I have a worksheet with many hundreds of rows of data and 16 columns. In
column P there is an identifier (numeric). Can I use a formula in a second
worksheet to reproduce the first worksheet but only picking out the rows
where either the identifier is unique or in the case where there are
duplicates picking out just one of these rows (any one will do).
Thanks!!
|