LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Highlight Duplicate Values in a Range

An employee imports data (numerical values) into the range A1:T93 each
week. Some values are duplicated within the range, but because the
data is different each time, the values that are duplicated change from
week to week, and she has no easy way to determine which values are
duplicated or how often.

If a number appears in just 2 different cells, it's no problem. But if
a number appears in 3 or more cells, she needs to know that.

Is there some code that can run through the range to determine values
that appears in 3 or more cells and highlight them somehow (ideally
changing the background color of those cells).

As an example, if cells A6, B32 and M45 all contain the number 16, and
cells C9, F13, G83, H2 and R19 contain the number 32, she'd like the
background color of all 8 cells to be changed (say to yellow). (I used
16 and 32 as an example, but the numbers that are duplicated change
from week to week, and usually there are several different numbers
duplicated, not just 2.)

By the way, if finding those in 3 or more cells complicates things too
much vs. just finding those that appear in 2 or more cells, we can live
with that.

Many thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying duplicate values in a range Paul Excel Discussion (Misc queries) 1 May 3rd 09 10:31 PM
Duplicate values in range of fields Donna Excel Discussion (Misc queries) 2 February 6th 09 06:23 PM
How to Highlight Two Rows With Two Columns of Duplicate Values JSteph Excel Worksheet Functions 1 December 12th 07 01:59 AM
how do i prevent duplicate values in a range of validated cells? scw Excel Discussion (Misc queries) 1 December 20th 06 09:43 AM
is there a formula that remove duplicate values from a range Martin R Excel Worksheet Functions 3 June 20th 06 01:10 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"