Good afternoon!
Below is a sample of a very large Excel file. The columns across are record number, material type code, title, and series name.
Here's what I need: If the title matches, look in the series name column and highlight the ones that are different. See how the first two lines are missing the |v? I want those highlighted. I'm thinking conditional formatting of some sort?
b1481815a
5
Kindred in death
|aEve Dallas mysteries ; 29
b1461286a
7
Kindred in death
|aEve Dallas mysteries ; 29
b1459533a
8
Kindred in death
|aEve Dallas mysteries ;|v29
b1455210a
b
Kindred in death
|aEve Dallas mysteries ;|v29
b1459552a
c
Kindred in death
|aEve Dallas mysteries ;|v29
b1459696a
l
Kindred in death
|aEve Dallas mysteries ;|v29
Here's an example of a larger selection...notice how the sheet is sorted by title, then by series name...
b1474087a
b
Kind of blue
|aAsh Levine mysteries ;|v1
b1527205a
b
Kind of cruel
|aSimon Waterhouse and Charlie Zailer series ;|v7
b1533378a
l
Kind of cruel
|aSimon Waterhouse and Charlie Zailer series ;|v7
b1546992a
j
Kindergarten phonics & ABCs
|aStar Wars workbooks
b1534826a
b
Kindle Fire HD : the missing manual
|aMissing manual
b1534826a
b
Kindle Fire HD : the missing manual
|aMissing manual
b1518533a
b
Kindle Fire HD for dummies
|a--For dummies
b1540426a
b
Kindle Fire HDX for dummies
|aFor dummies
b1499791a
b
Kindle Fire quicksteps
|aQuickSteps
b1540427a
b
Kindle Paperwhite for dummies
|aFor dummies
b1518532a
b
Kindle Paperwhite for dummies
|a--For dummies
b1506476a
5
Kindness goes unpunished
|aA Walt Longmire mystery
b1506476a
5
Kindness goes unpunished
|aJohnson, Craig,|d1961-|tWalt Longmire mystery
b1399093a
b
Kindness goes unpunished
|aWalt Longmire mysteries ;|v3
b1481815a
5
Kindred in death
|aEve Dallas mysteries ; 29
b1461286a
7
Kindred in death
|aEve Dallas mysteries ; 29
b1459533a
8
Kindred in death
|aEve Dallas mysteries ;|v29
b1455210a
b
Kindred in death
|aEve Dallas mysteries ;|v29
b1459552a
c
Kindred in death
|aEve Dallas mysteries ;|v29
b1459696a
l
Kindred in death
|aEve Dallas mysteries ;|v29
Any ideas of how I can do this?
Thanks!
Eddie
Eddie Clem, MLS
Cataloging Librarian
Outreach and Collection Services
Kokomo-Howard County Public Library
305 East Mulberry Street
Kokomo, IN 46901
765.626.0853|765.450.6290 (fax)
[log in to unmask]<mailto:[log in to unmask]> | www.KHCPL.org<http://www.khcpl.org/>
WorldCat Discovery now includes selected
Howard County Memory Project Collections!
[http://www.oclc.org/content/dam/oclc/worldcat-discovery/discovery-templates/215320-EG-blue-1.jpg]<khcpl.on.worldcat.org>
|
