Re: Check for duplicate entries???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I got it "kinda" working...lol. I sent the format to shade the background of
the cell red. When I enter in a duplicate item, the original item does get
highlighted, buy the one I just entered does not. This doesn't work to well
as usually the original item will be so far from the newly entered one I
won't see it until later when I happen to view that section of the workbook.

Any idea why it is not changing the new entered cell?

Thanks again.



"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4930820B.56713120@xxxxxxxxxxxxxxxxxxx
That's exactly what I mean.

You can tell the difference in the activecell by its color. It's
different--usually white while the rest of the selection is blue.



FISH wrote:

I'm still doing something wrong. Obviously I'm a newbie so just want to
make
sure I'm reading the instructions correctly.

When you say make sure the cells within the values are highlighted, do
you
simple mean start at the beginning of the range and drag the highlighted
section all the way to the end of the range? So just start at C5 and hold
the left mouse button down while scrolling all the way down to C3000,
right?

Once that range is highlighted, how do I make sure C5 is the active cell
(without the highlighted range from C5-C300 to stop being highlighted)?

Thanks again and sorry for the very basic help I'm needing help with.

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:492DDF94.6D268A5@xxxxxxxxxxxxxxxxxxx
I think you messed up when you applied the conditional formatting.

The cells with the values should be highlighted--not the cells above
the
duplicates.

Make sure you select C5:C3000
and with C5 the activecell, do the format|conditional formatting
formula is:
=countif($c$5:$c$3000,c5)>1

====
Just a personal choice.

I like to use a helper column with the same formula. Then I can use
data|filter|autofilter to see the True's (duplicates).

I find it easier than scrolling looking for color changes.

FISH wrote:

Thank you. I went to his site and tried the "Highlighting Duplicate
Entries"
instructions, but it doesn't work properly.

For example: If I have an item in C6 and I enter that same item in
C50,
only
C5 (one line above) gets highlighted. The duplicate I entered in C50
and
other duplicate in C6 remain unchanged.

I followed the instructions on that site and have checked the code a
few
times. My exact code (because my range is from C5:C3000) is:

In Conditional Formatting
I change the first box to "Formula is"
Then I enter this code in the next box: =COUNTIF($C$5:$C$3000,C5)>1

Any idea what I'm doing wrong?

I would like to set this up so when I enter in a duplicate item, both
duplicate items are highlighted.

Thanks!!!

Here are the instructions from the site that I followed:

This first example will highlight duplicate rows in the range B2:B11.
Select
the cells that you wish to test and format, B2:B11 in this example.
Then,
open the Conditional Formatting dialog from the Format menu, change
Cell
Value Is to Formula Is, enter the formula below, and choose a font or
background format to apply to cells that are duplicates.

=COUNTIF($B$2:$B$11,B2)>1

The formula above, when used in Conditional Formatting, will
highlight
all
duplicates. That is, if the value 'abc' occurs twice in the list, both
instances of 'abc' will be highlighted. This is shown in the image to
the
left, in which all occurrences of 'a' and 'g' are higlighted.

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:492C4F98.701A9C3B@xxxxxxxxxxxxxxxxxxx
You may want to look at Chip Pearson's site. He has lots of
techniques
to
work
with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

FISH wrote:

Sorry in advance for the newbie type question :)

I'm going to be making a long list of items and prices. I will be
getting
to
the point I will come across the same item again and want to make
sure
I
don't have duplicate entries.

Is there a way in Excel to check and see if that entry has already
been
entered in the workbook?

I assume there are a couple ways, but how would you set things up
to
check
to prevent duplicate entries?

Thanks

(I'm using Excel 2002)

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson


.

Relevant Pages

  • Re: Check for duplicate entries???
    ... When you say make sure the cells within the values are highlighted, ... I went to his site and tried the "Highlighting Duplicate ... In Conditional Formatting ... This first example will highlight duplicate rows in the range B2:B11. ...
    (microsoft.public.excel)
  • Re: Check for duplicate entries???
    ... When you say make sure the cells within the values are highlighted, ... I went to his site and tried the "Highlighting Duplicate ... In Conditional Formatting ... This first example will highlight duplicate rows in the range B2:B11. ...
    (microsoft.public.excel)
  • RE: Look for duplicates within a range
    ... multiple cells. ... Then, highlight a large selection, starting in A2, and down to D (whatever ... Menu Fortmat|Conditional Formatting ... the 4 sets of data, it matches up to all the rows above, and if a duplicate, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Check for duplicate entries???
    ... When you say make sure the cells within the values are highlighted, ... I went to his site and tried the "Highlighting Duplicate ... In Conditional Formatting ... This first example will highlight duplicate rows in the range B2:B11. ...
    (microsoft.public.excel)
  • Re: Check for duplicate entries???
    ... When you say make sure the cells within the values are highlighted, ... I went to his site and tried the "Highlighting Duplicate ... In Conditional Formatting ... This first example will highlight duplicate rows in the range B2:B11. ...
    (microsoft.public.excel)