My database got messed up. Our clothing styles come in sizes small, medium, large. Somehow a few hundred styles all got the same size attached to them. I need to isolate these styles that have duplicate sizes.
Attached is an example of the output I'm looking for.
Thanks!
Last edited by Ocean Zhang; 03-13-2012 at 04:27 PM.
try like this the conditional format applied to b2 =COUNTIF($C$2:$C$10000,$C2)>1 copied across then down
col c is what is being checked
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
consider employing Advanced Filter.
Data tab > Sort and Filter group > Advanced Filter
oops, i think i mistook your question - i realised after seeing @martindwilson's response.
Wow, I never even thought of joining the 2 columns. Duh! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks