Removing Duplicates 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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!

Removing Duplicates Help
 

See:
Listing Distinct Elements In A List
in:
http://www.cpearson.com/excel/ListFunctions.aspx
--
Gary''s Student - gsnu200851


"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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!

Removing Duplicates Help
 

Hi,
Try
=IF(COUNTIF($C$11:C11,C11)=1,C11,"")

Change the range to fit your needs

If this was helpful please click yes, thanks

"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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!

Removing Duplicates Help
 

Still isn't working. Any other ideas?



"Gary''s Student" wrote:

See:
Listing Distinct Elements In A List
in:
http://www.cpearson.com/excel/ListFunctions.aspx
--
Gary''s Student - gsnu200851


"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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!

Removing Duplicates Help
 

Still not returning any values. For our example, I'm testing on a blank
worksheet.

Cells A1:A4 contain:
White
Red
Blue
White

Starting in Cell B1:B4, I want to only list the unique entries. So I'd like
for B1:B4 to read:
White
Red
Blue

Notice B4 is left blank because of the duplicate "White" text value.

I tried the recommended formula, but am not returning ANY values what so
ever.




"Eduardo" wrote:

Hi,
Try
=IF(COUNTIF($C$11:C11,C11)=1,C11,"")

Change the range to fit your needs

If this was helpful please click yes, thanks

"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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!

Removing Duplicates Help
 

Hi Scott
try again I tested and it works only bring the colours once for your example
enter this in B1 and copy down
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

"Scott" wrote:

Still not returning any values. For our example, I'm testing on a blank
worksheet.

Cells A1:A4 contain:
White
Red
Blue
White

Starting in Cell B1:B4, I want to only list the unique entries. So I'd like
for B1:B4 to read:
White
Red
Blue

Notice B4 is left blank because of the duplicate "White" text value.

I tried the recommended formula, but am not returning ANY values what so
ever.




"Eduardo" wrote:

Hi,
Try
=IF(COUNTIF($C$11:C11,C11)=1,C11,"")

Change the range to fit your needs

If this was helpful please click yes, thanks

"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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!

Removing Duplicates Help
 

Thanks! I got it to work!

"Eduardo" wrote:

Hi Scott
try again I tested and it works only bring the colours once for your example
enter this in B1 and copy down
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

"Scott" wrote:

Still not returning any values. For our example, I'm testing on a blank
worksheet.

Cells A1:A4 contain:
White
Red
Blue
White

Starting in Cell B1:B4, I want to only list the unique entries. So I'd like
for B1:B4 to read:
White
Red
Blue

Notice B4 is left blank because of the duplicate "White" text value.

I tried the recommended formula, but am not returning ANY values what so
ever.




"Eduardo" wrote:

Hi,
Try
=IF(COUNTIF($C$11:C11,C11)=1,C11,"")

Change the range to fit your needs

If this was helpful please click yes, thanks

"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. This is something that I want to automatically calculate. The
text values in Cells A1:A4 are subject to change and are not constant, so, I
would want to automatically remove those duplicate values, and if there's a
change in A1:A4, it'll automatically update in B1:B4.

So my column should read

Cells B1:B3

White
Red
Blue

Does this involve an INDEX formula or what formula do I use to accomplish
this? Thanks!