View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Reference & Duplicate Data Help

I've got the following series of data (maximum of 4 data fields per group)

Cells A1:A4

White
Red
White
Blue

I want to produce a list in another column to pull those values minus
duplicates. So my column should read

Cells B1:B3

White
Red
Blue

What formula do I use to accomplish this? Thanks!