+ Post New Thread
Results 1 to 3 of 3
Windows Thread, Excel Not Recognizing Cells of Equal Value in Technical; I have been trying to help remove duplicate records from a large list of records using excel. The records were ...
  1. #1

    Join Date
    Jun 2007
    Location
    Maryland, US
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Excel Not Recognizing Cells of Equal Value

    I have been trying to help remove duplicate records from a large list of records using excel. The records were orginally part of two separate csv files, which were combined once they had been converted to excel format. The problem is that when I try to compare values that look the same but came from a different list, excel says they are not equal.

    For example, I have excel looking to see if the last name in the next record (row) is the same as the last name of the current record (row) ["=if(d2=d3,1,0)] So if the last names are the same it should return a 1 and if they are different a 0. For some reason when cells which have the same value in them (e.g. "Smith") but each is from a different inital list, the formula says the cells' values are different; and the formula works fine if the two rows come from the same initial list.

    I have checked and there are no leading or trailing spaces in the cells, there are no special characters in any of the cells, and I have tried saving the excel file into csv and converting it back to excel in order to remove any weird formating issues. I have even tried using different versions of excel with no success.

    I am completely stumped...some one please help!

    Cheers,

    Greg

  2. #2

    Join Date
    Feb 2007
    Location
    Lincolnshire
    Posts
    120
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Excel Not Recognizing Cells of Equal Value

    If the cells are numeric cells set them to numeric

    select all your cells right click format cells then select number from the list and try the comparison again.

    failing that if they are text values do the same as above but change it from general to text.

    hope that helps

  3. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: Excel Not Recognizing Cells of Equal Value

    Wow i didnt know we had members from the US Ok im not really sure whats going on with your spreadsheet but if you could post it i could have a look at it.

    I have a macro that i use to remove duplicates for some of my sims reports:

    Code:
    Sub DeleteDuplicates()
        Dim i, j
    
        i = 2
    
        Do While Range("E" & i).Value <> ""
            j = i - 1
            If Range("F" & i).Value <> "" Then
                If Range("F" & i) = Range("F" & j) Then
                    Range("A" & i, "F" & i).Select
                    Selection.Delete Shift:=xlUp
                End If
            End If
            i = i + 1
        Loop
    
    End Sub
    NOTE: This code will compare 2 cells to see if they are the same and if they are it will delete it. It will continue to do this till it hits a blank cell, which should be the end.

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  2. excel in explorer
    By Uraken in forum How do you do....it?
    Replies: 2
    Last Post: 18th October 2007, 02:07 PM
  3. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  4. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM
  5. Excel frustration
    By GrumbleDook in forum Windows
    Replies: 3
    Last Post: 24th August 2005, 10:01 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •