+ 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
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: double entry findings issue

    maybe use CF for whole column of mail addresses

    dup.jpg
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  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
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: double entry findings issue

    You are welcome

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    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. [SOLVED] Double Entry table
    By Mnilo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2006, 03:29 AM
  6. FIND - Double entry
    By Danny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2005, 04:05 PM
  7. Double entry problem
    By Jesper Perregaard in forum Excel General
    Replies: 1
    Last Post: 08-18-2005, 07:05 AM
  8. 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