Thread: Unique Records
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ronan Ronan is offline
external usenet poster
 
Posts: 11
Default Unique Records

Hi, is there a way of returning the list of unique records from a list of
data. For example, my list could contain 1, 1, 2, 3, 1, 2, 9, 1, 4, 5, 4, 4,
3, 2, 3, etc... I know I can use the frequency function but my list has over
2000 entries and I dont know what the actual unique list of numbers is in
order to use the frequency function. I could also use a pivot table but was
hoping to use some formula or formulae.

Hope this makes sense

Thanks.