Reference & Duplicate Data Help

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

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!
 
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
 
That doesn't seem to work. It's not filtering out the duplicate "White" text
value. Also, this is something that I want to automatically calculate. The
text values in cells A1:A4 in our example are subject to change and are not
constant. I want to filter out those duplicate text values automatically.
So if there is a change in A1:A4, changes in B1:B4 are automatically done.

Wouldn't this involve an INDEX formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing Duplicates Help 6
IF AND OR STATEMENT 3
Stop duplicate data 1
Shift down and then to the right 1
Text to rows 4
mr t.valko ..help 8
This should be simple 6
Highlite Duplicates in 2 Columns (Conditional Formating) 3

Back
Top