Closed Thread
Results 1 to 6 of 6

how to check/trace duplicate number or data in list

  1. #1
    Registered User
    Join Date
    01-14-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    how to check/trace duplicate number or data in list

    hi there..
    is anyone know how to trace/check the duplicate number/data in excell list?
    e.g: phone no.

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: how to check/trace duplicate number or data in list

    Vist this sites

    With Conditional Formatting

    Prevent duplicate with data validation
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, «Born in USSR»
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Registered User
    Join Date
    01-14-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: how to check/trace duplicate number or data in list

    TQ very much..
    Last edited by teylyn; 01-19-2010 at 02:06 AM. Reason: del quote

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: how to check/trace duplicate number or data in list

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

  5. #5
    Registered User
    Join Date
    01-14-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    do you know how to separate the data like this.. refer e.g

    hi everybody..
    need ur help
    did anyone know how to separate the data as attached here
    which i want to separate data in column D between data contains word "info" and "poskod"
    TQ
    Attached Images Attached Images
    Last edited by sputet; 01-19-2010 at 02:38 AM.

  6. #6
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: how to check/trace duplicate number or data in list

    sputet, this seems to be a different, i.e. new question. Please start a new thread and attach sample data as an Excel file, not a picture!!

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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