assume the values are in column A, select column A by clicking the column header,
do format>conditional formatting, select formula is and use
=COUNTIF($A$1:A1,A1)>1
click the format button, choose patterns and the highlight colour, click OK twice and you are
done.. This will not highlight the first occurrence of the duplicate value..
If you want to highlight all occurrences of the duplicates change the formula to
=COUNTIF(A:A,A1)>1
If your intention is to get a list with unique value, see
data>advanced filter, check unique records only and copy to another location..
--
Regards,
Peo Sjoblom
<rvh...@optonline.net> wrote in message news:3cdaa097...@news-server.optonline.net...
> If I have a spreadsheet of 500 values in one column and I sort it by
> ascending values, how can I make a maro or use a formatting command to
> highlight duplicate values? Any ideas. Thanks
On Mon, 6 May 2002 10:44:43 -0500, "Wilson" <jwi...@wickes.com>
wrote:
Greg
"Wilson" <jwi...@wickes.com> wrote in message
news:O$uW9RR9BHA.1612@tkmsftngp07...
Doe, Jon
Doe, John
Dog, Chris
Dorth, Stacey
Both the first and last name are in a sinlge cell separated by a
comma. Is there a way to highlight the cell if the last name is a
duplicate, only the name up to thte comma?
Example, in the list above, how would I write the code so the first
two entries would be highlighted because the last names are the same,
basically duplicates.
Thanks again,
Bob
On Mon, 6 May 2002 10:44:43 -0500, "Wilson" <jwi...@wickes.com>
wrote:
>You can use Conditional Formatting from the Menu, but code is more fun
=COUNTIF(A:A,"="&LEFT(A1,FIND(",",A1))&"*")>1
will highlight in this case the first 2 rows..
alternative formula
=SUMPRODUCT((ISNUMBER(SEARCH(LEFT(A1,FIND(",",A1)),$A$1:$A$30)))*1)>1
adapt to fit your actual data
--
Regards,
Peo Sjoblom
<rvh...@optonline.net> wrote in message news:3cd6ea01...@news-server.optonline.net...
On Mon, 6 May 2002 17:39:27 -0400, "Peo Sjoblom" <ter...@mvps.org>
wrote:
Greg
"Wilson" <jwi...@wickes.com> wrote in message
news:#pYeKqS9BHA.1304@tkmsftngp07...