Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
REPEATED VALUES!
In range("A1:AZ4000").cells are data. This macro should check to ensure
that EACH figure in the above range appears ONLY ONCE. If there are more than one of ANY value, then it should color the cells containing the additional (redundant or repeated) values red. Any help would be appreciated. Thanks Jay Dean *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
REPEATED VALUES!
Hi
Have a look at some of Debra Dalgeish's stuff using formulas in conditional formatting http://www.contextures.com/xlCondFor...html#Duplicate regards Paul jay dean wrote: In range("A1:AZ4000").cells are data. This macro should check to ensure that EACH figure in the above range appears ONLY ONCE. If there are more than one of ANY value, then it should color the cells containing the additional (redundant or repeated) values red. Any help would be appreciated. Thanks Jay Dean *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
REPEATED VALUES!
I appreciate the info., but I will need a macro. This is to process a
lot a data in several varying ranges in which fixed formulas will not be very useful. Any help would be appreciated! Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeated values | Excel Worksheet Functions | |||
Top 10 with Repeated Values | Excel Discussion (Misc queries) | |||
Repeated values in a row | Excel Discussion (Misc queries) | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Formatting Repeated Values | Excel Programming |