Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate values
Hi
I need to find and list (or change color of the row) all values which are duplicated in Col B. How to do this? s. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate values
Hi,
try =COUNTIF($B$1:$b$100,B1)1 as your conditional formatting formula. Or put the formula into a separate column and format based on TRUE I don't think so, this is what I asked for, but thank you for try. Maybe I need a macro ... For example: Col B f g h k g h m I would like to change for red color every duplicated value in col B: g, h should be RED |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate values
Hi, that is what my suggestion will highlight.
for the data sample you named: Select the cells in column B, click Conditional formatting - Formula Is Thank you, now works fine! (I think I miss understood the first post, because I tried but it not worked out). s. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DUPLICATE VALUES | Excel Discussion (Misc queries) | |||
DUPLICATE VALUES | Excel Worksheet Functions | |||
Duplicate values | Excel Discussion (Misc queries) | |||
Duplicate values | Excel Worksheet Functions | |||
Sum of Duplicate Values | Excel Worksheet Functions |