View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nackington nackington is offline
external usenet poster
 
Posts: 1
Default 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!!