+ Reply to Thread
Results 1 to 4 of 4

Countif for long strigns of characters

  1. 03-11-2020, 02:24 AM #1
    kmmukesh
    kmmukesh is offline
    Registered User
    Join Date
    02-21-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Countif for long strigns of characters

    Hi, need help- I am trying to identify the duplicates using Countif formula, however, because of the long strings- it is showing erroneous sets. Any workaround?

    Thanks,
    M
    Reply With QuoteRegister To Reply
  2. 03-11-2020, 03:24 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Countif for long strigns of characters

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 03-11-2020, 04:43 AM #3
    kmmukesh
    kmmukesh is offline
    Registered User
    Join Date
    02-21-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Re: Countif for long strigns of characters

    Thank you, attached the same example sheet. Please help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-11-2020, 05:58 AM #4
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Countif for long strigns of characters

    Hi,

    Try the below formula in L2:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Remove 7 characters from the middle of a long text string
    By jsohng in forum Excel General
    Replies: 9
    Last Post: 02-13-2017, 01:22 PM
  2. Splitting a long text by words not characters
    By Stwong in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2015, 10:17 PM
  3. Trim A Cell Only If It's 4 Characters Long
    By mightyeskimo in forum Excel General
    Replies: 3
    Last Post: 03-03-2012, 11:56 AM
  4. Is it possible to compare characters within in a long string ?
    By emgo19 in forum Excel General
    Replies: 1
    Last Post: 10-19-2011, 07:48 AM
  5. Adding 0's before a text to make it 6 characters long
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-21-2010, 05:37 AM
  6. [SOLVED] How parse out characters from long string?
    By Chet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2006, 06:10 PM
  7. [SOLVED] last digit in string gets changed to 0 (16 characters long)
    By Mike Milmoe in forum Excel General
    Replies: 3
    Last Post: 06-29-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1