• Login
Community
  • Login

How to highlight the Duplicate numbers in Notepad++

Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
5 Posts 3 Posters 16.2k Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J
    Jinko Solar
    last edited by Jinko Solar Jul 2, 2019, 1:15 PM Jul 2, 2019, 1:13 PM

    How to highlight the Duplicate numbers by Color in Notepad++
    Like this.
    0314 2960618
    0300 2672753
    0314 2960618

    A 1 Reply Last reply Jul 2, 2019, 7:48 PM Reply Quote 0
    • A
      Alan Kilborn @Jinko Solar
      last edited by Jul 2, 2019, 7:48 PM

      @Jinko-Solar

      1. Double-click one of the numbers. All other instances of that number will be highlighted in light green. Presumes Smart Highlighting is on, but it is on by default, so…

      2. Search (menu) > Mark… With an appropriate Find-what box content, your duplicate numbers will be highlighted in red.

      3. Search (menu) > Mark All. This might be the best option as it gives you 5 different colors.

      1 Reply Last reply Reply Quote 3
      • J
        Jinko Solar
        last edited by Jul 3, 2019, 5:47 AM

        Thanks Sir, But I am looking this type Solution In Notepad++

        "How to highlight cell if value duplicate in same column for google spreadsheet?
        Select the whole column
        Click Format
        Click Conditional formatting
        Click Add new rule
        Set Format cells if to: Custom formula is:
        Set value to: =countif(A:A,A1)>1
        Set the formatting style.
        Ensure the range applies to your column (e.g., A1:A100).
        Anything written in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it’ll be coloured.

        For locales using comma (,) as a decimal separator, the argument separator is most likely a semi-colon (;). That is, try: =countif(A:A;A1)>1, instead."

        E 1 Reply Last reply Jul 3, 2019, 11:15 AM Reply Quote 0
        • E
          Ekopalypse @Jinko Solar
          last edited by Jul 3, 2019, 11:15 AM

          @Jinko-Solar

          No, npp is a text editor, not a spreadsheet replacement.

          1 Reply Last reply Reply Quote 2
          • J
            Jinko Solar
            last edited by Jul 4, 2019, 5:57 AM

            Sir, O.K.

            1 Reply Last reply Reply Quote 0
            2 out of 5
            • First post
              2/5
              Last post
            The Community of users of the Notepad++ text editor.
            Powered by NodeBB | Contributors