Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: If Statement For Duplicate Entries

  1. #1
    Join Date
    7th February 2007
    Posts
    14

    If Statement For Duplicate Entries

    Hi,

    I have a spreadsheet which has data in column A & B. I trying to do an if statement to state "YES" if data in both A and B has been duplicated. EG 111 in (A) & 222 in (B) are a PAIR, im need an if statemnet in Column (C) to say if this PAIR are duplicated in these two columns return "YES". I have tried THREE different methods to do acheive this which are in the attached document. The main issue I am having is the iff statement is returning yes for some of the number when thye are completely different. I have used concatenate, & and tried to multiply the two values to try to make it unique. I have an example of each in the separate tabs.

    Thanks
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th March 2007
    Location
    LONDON, UK
    Posts
    1,377

    Re: If Statement For Duplicate Entries

    Have you tried using a pivot table? seems a better approach

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: If Statement For Duplicate Entries

    Your formulas are correct. The reason why you are getting the wrong result is that you are comparing numbers with more digits than Excel can hold, so they look the same.

    EDIT: Although these are text strings, because there are no alphabetic characters, for the comparison, Excel is taking their value. If you add an alpha character, they will not then compare equal.
    Last edited by ByTheCringe2; March 27th, 2007 at 20:01.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: If Statement For Duplicate Entries

    Note: previous post undeleted and edited.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    7th February 2007
    Posts
    14

    Re: If Statement For Duplicate Entries

    Thanks for your help that works fine. Your right I'm kicking myself.!!

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: If Statement For Duplicate Entries

    Could you specify who you are replying to, please? Bradles answer is not right.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    21st September 2006
    Posts
    312

    Re: If Statement For Duplicate Entries

    Hmmm...

    I think you may be right ByTheCringe2...he did have >1 in the formula. Now I'm kicking myself...I must be tired.

    EDIT: If you wish, you can delete my post above...it is incorrect.
    Last edited by bradles; March 27th, 2007 at 20:39.
    Brad.

  8. #8
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: If Statement For Duplicate Entries

    It actually looks like an Excel bug really, doesn't it? It had me going there for a while!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Once-off And Duplicate Entries
    By AEther in forum EXCEL HELP
    Replies: 1
    Last Post: November 16th, 2006, 16:59
  2. Stop Duplicate Entries
    By steve1262 in forum EXCEL HELP
    Replies: 4
    Last Post: August 25th, 2006, 10:28
  3. Duplicate entries in ComboBox
    By dagreensta in forum EXCEL HELP
    Replies: 2
    Last Post: July 21st, 2005, 19:56
  4. Duplicate Entries
    By Analyst84 in forum EXCEL HELP
    Replies: 1
    Last Post: May 13th, 2004, 05:13
  5. Deleting Duplicate Entries
    By bearcub in forum EXCEL HELP
    Replies: 19
    Last Post: February 12th, 2003, 05:06

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
  •  
porno