Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Basically I have a list of people from A2:A1475 who report into people in
N2:N1475. I need to highlight everyone in column A who is duplicated in column N but do not report into themselves, so when row A and N don't match. I'm guessing I have to use conditional formatting but I really need help with it. Many thanks in advance Sam.D |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Maybe this suffices
Select A2:A1475 (A2 active), then apply CF using Formula Is: =COUNTIF($N:$N,A2) Format to taste, ok out -- Max Singapore --- "Sam.D" wrote: Basically I have a list of people from A2:A1475 who report into people in N2:N1475. I need to highlight everyone in column A who is duplicated in column N but do not report into themselves, so when row A and N don't match. I'm guessing I have to use conditional formatting but I really need help with it. Many thanks in advance Sam.D |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Thanks,
Unfortunately this highlights all duplicates. I only need the duplicates highlighted when they do not report directly into themselves as in when what is in row A does not match row N. Sorry for my vague explanation. Sam.D "Max" wrote: Maybe this suffices Select A2:A1475 (A2 active), then apply CF using Formula Is: =COUNTIF($N:$N,A2) Format to taste, ok out -- Max Singapore --- "Sam.D" wrote: Basically I have a list of people from A2:A1475 who report into people in N2:N1475. I need to highlight everyone in column A who is duplicated in column N but do not report into themselves, so when row A and N don't match. I'm guessing I have to use conditional formatting but I really need help with it. Many thanks in advance Sam.D |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Try this as the CF formula for the dual condition:
=AND(COUNTIF($N:$N,A2),A2<N2) Success? celebrate it, hit the YES below -- Max Singapore --- "Sam.D" wrote: Thanks, Unfortunately this highlights all duplicates. I only need the duplicates highlighted when they do not report directly into themselves as in when what is in row A does not match row N. Sorry for my vague explanation. Sam.D |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
No Success I'm afraid.
Still has the same results. Can I use formatting on both conditions? Sam.D "Max" wrote: Try this as the CF formula for the dual condition: =AND(COUNTIF($N:$N,A2),A2<N2) Success? celebrate it, hit the YES below -- Max Singapore --- "Sam.D" wrote: Thanks, Unfortunately this highlights all duplicates. I only need the duplicates highlighted when they do not report directly into themselves as in when what is in row A does not match row N. Sorry for my vague explanation. Sam.D |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Lost you there, I'm afraid. It should have worked. Maybe you could post some
sample/representative data from the 2 cols. Indicate exactly which data are to be highlighted by the CF. -- Max Singapore ---- "Sam.D" wrote in message ... No Success I'm afraid. Still has the same results. Can I use formatting on both conditions? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Please excuse me, it does work perfectly.
Many thanks for your help Sam.D "Max" wrote: Lost you there, I'm afraid. It should have worked. Maybe you could post some sample/representative data from the 2 cols. Indicate exactly which data are to be highlighted by the CF. -- Max Singapore ---- "Sam.D" wrote in message ... No Success I'm afraid. Still has the same results. Can I use formatting on both conditions? . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I highlight duplicates from 2 rows using set criteria
Glad to hear. You're welcome.
-- Max Singapore "Sam.D" wrote in message ... Please excuse me, it does work perfectly Many thanks for your help Sam.D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight rows if duplicates are found | Excel Worksheet Functions | |||
Highlight Duplicates with different Color | Excel Discussion (Misc queries) | |||
Deleting rows by specified criteria for duplicates | Excel Discussion (Misc queries) | |||
Highlight Duplicates, Macro? | Excel Worksheet Functions | |||
How do i locate/highlight duplicates ? | Excel Discussion (Misc queries) |