| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing duplicates | Excel Discussion (Misc queries) | |||
| Removing Duplicates | Excel Worksheet Functions | |||
| removing duplicates | Excel Discussion (Misc queries) | |||
| Removing Duplicates | Excel Discussion (Misc queries) | |||
| Removing Duplicates | Excel Worksheet Functions | |||
Linear Mode
