Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Intota

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Intota
    3. Intota
    4. Product Documentation
    5. Assessment
    6. eResources Usage Data
    7. Intota: COUNTER Reports
    8. Intota: Uploading COUNTER Reports
    9. 360 Counter and Intota: Finding Duplicate Titles in Usage-Data Reports to be Uploaded

    360 Counter and Intota: Finding Duplicate Titles in Usage-Data Reports to be Uploaded

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. How do I find and get rid of duplicate titles in usage-data reports before uploading into 360 Counter or Intota?
    • Product: 360 Counter and Intota

    How do I find and get rid of duplicate titles in usage-data reports before uploading into 360 Counter or Intota?

    Sometimes the usage-data reports you receive from a provider contain duplicate titles. Before uploading the report into 360 Counter's or Intota's Consolidated Reports system, you need to remove those.
    Here is an easy way to find duplicate titles using Microsoft Excel 2007, as suggested by a customer.  We believe the process is essentially the same for later versions of Excel as well:
    1. Highlight the whole column(s) you want to check for duplicates.
    2. On the Home tab, in the Styles section, click Conditional Formatting, then select Highlight Cells Rules, then select Duplicate Values.
    3. Choose a color combination you like and click OK.
    4. You can scroll down and look for color, or simply use the Filter by Color function (described in Excel's help files).
    5. If you find a duplicate, you can delete the line or change the text and the color goes away.
    You should clear the conditional-formatting function before leaving the spreadsheet. On big spreadsheets, leaving it activated can really slow down sorting, saving, and so forth:
    1. Go back to the Conditional Formatting function.
    2. At the bottom of the Conditional Formatting drop-down menu, select Clear Rules and then Clear Rules from Entire Sheet.

    • Date Created: 9-Feb-2014
    • Last Edited Date: 21-Feb-2014
    • Old Article Number: 7184
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Intota: Uploading COUNTER Reports
      • Intota: Format for Uploading Usage Data Spreadsheets
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Intota
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved