+ Reply to Thread
Results 1 to 5 of 5

double entry findings issue

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    Dhaka bangladesh
    MS-Off Ver
    office 2013
    Posts
    8

    double entry findings issue

    Hello there.
    the situation is. i have an excel file with 10K mail address. now i would like to add some more email address on that file. but i dont want any double entry with it. If i add any entry which is already in there only that entry will show with some different color or something so i can understand its already there. i dont want any email address will be erresed autometically. it will show me which i need work.

    Thank you.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: double entry findings issue

    maybe use CF for whole column of mail addresses

    dup.jpg

  3. #3
    Registered User
    Join Date
    03-20-2018
    Location
    Dhaka bangladesh
    MS-Off Ver
    office 2013
    Posts
    8

    Re: double entry findings issue

    it worked.. Thank you dear....

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: double entry findings issue

    You are welcome

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: double entry findings issue

    I think could be better to avoid duplicates via DataValidation

    eg. A = column of mails
    select whole A column
    Data - Data Validation
    Allow = Custom
    Formula: COUNTIF(A:A,A1)=1
    Ok

    it works if mails are manually entered so you can use both way against copy/paste
    Last edited by sandy666; 03-30-2018 at 12:58 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-12-2013, 12:37 AM
  2. Finding Double entry
    By chandan12 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 12:08 PM
  3. single entry to double entry
    By ice1980 in forum Excel General
    Replies: 2
    Last Post: 04-21-2009, 12:45 PM
  4. double entry
    By bananaman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-31-2007, 09:08 AM
  5. Double Entry table
    By Mnilo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2006, 03:29 AM
  6. [SOLVED] FIND - Double entry
    By Danny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2005, 04:05 PM
  7. [SOLVED] Double entry problem
    By Jesper Perregaard in forum Excel General
    Replies: 1
    Last Post: 08-18-2005, 07:05 AM
  8. [SOLVED] Double entry
    By Rob graham in forum Excel General
    Replies: 6
    Last Post: 06-21-2005, 04:05 AM

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