Reference & Duplicate Data Help
Select the range A1:A4
Choose Data-Filter-Advance Filter
List Range box will have A1:A4
Check the checkbox 'COpy to another location' and enter B1 in the 'Copy to'
box
Check 'Unique records only'
Click Ok
"Scott" wrote:
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!
|