+ Reply to Thread
Results 1 to 6 of 6

Check for duplicate, then if found check for any changes in a different column?

  1. 02-29-2012, 06:49 AM #1
    brenweb
    brenweb is offline
    Registered User
    Join Date
    02-29-2012
    Location
    Aberdeen
    MS-Off Ver
    Proffesional plus 2010
    Posts
    3

    Check for duplicate, then if found check for any changes in a different column?

    Hi,

    I copy and paste information direct from SAP into EXCEL daily to check if any new items have been added to a particulart list. I paste the new list directly under the list from yesterday and use conditional formatting to highlight the duplicates of column A (showing the new items as unhighlighted). I then delete the duplicate rows manually on the lower list.

    My question is while checking for the duplicates in column A between the two lists, and a duplicate is identified; is it possible to highlight any changes to say column B?

    eg.29-02-2012 11-06-50.jpg

    Can the increase in List 2 Column B for value 234 be identified between the duplicates?

    Hope this makes sense?

    Thanks.
    Last edited by brenweb; 02-29-2012 at 07:08 AM. Reason: formatting of columns didnt work
    Reply With QuoteRegister To Reply
  2. 02-29-2012, 07:09 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Check for duplicate, then if found check for any changes in a different column?

    How do you want the changes to be highlighted? Just in a different color?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 02-29-2012, 07:18 AM #3
    WHER
    WHER is offline
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Check for duplicate, then if found check for any changes in a different column?

    If i understand correctly: the change in column B makes it a non-duplicate? See attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-29-2012, 07:55 AM #4
    brenweb
    brenweb is offline
    Registered User
    Join Date
    02-29-2012
    Location
    Aberdeen
    MS-Off Ver
    Proffesional plus 2010
    Posts
    3

    Re: Check for duplicate, then if found check for any changes in a different column?

    Arlu1201 - Yes just a change of colour would be ok. Anything really just to make me aware there is a change.

    WHER - It is only column A that I am checking for duplicate values, then I wanted it to check column B to identify any change.
    Reply With QuoteRegister To Reply
  5. 03-02-2012, 07:00 AM #5
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Check for duplicate, then if found check for any changes in a different column?

    Why dont you attach a sample file instead of jpg?
    Reply With QuoteRegister To Reply
  6. 03-02-2012, 07:39 AM #6
    brenweb
    brenweb is offline
    Registered User
    Join Date
    02-29-2012
    Location
    Aberdeen
    MS-Off Ver
    Proffesional plus 2010
    Posts
    3

    Re: Check for duplicate, then if found check for any changes in a different column?

    Hi - Sorry, its my first post
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1