Results 1 to 5 of 5

TRUE/FALSE if Duplicate texts are present in a string

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2021
    Location
    Kolkata, India
    MS-Off Ver
    Microsoft Office Home and Student 2019
    Posts
    28

    TRUE/FALSE if Duplicate texts are present in a string

    Hi,

    I have a data array mixed with number and text. I want know if duplicate texts are present in that array. And also, I would like to highlight the cells containing duplicate texts.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to find a string in a row and return true or false
    By A2G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-18-2015, 03:28 PM
  2. True/False to display with a duplicate entry
    By chris37422 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2015, 04:45 PM
  3. Duplicate + True/False Formula
    By Stephen R in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2014, 12:26 PM
  4. [SOLVED] True/False Duplicate Formula
    By Stephen R in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2014, 10:10 AM
  5. [SOLVED] True False ( need duplicate not duplicate )
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2014, 03:49 AM
  6. Return True/False if a string of words is present in another list
    By tmahoney1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2013, 05:39 PM
  7. [SOLVED] Return True/False by searching a value in an array of string
    By aiyathomas in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-30-2013, 12:35 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1