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!
|