Results 1 to 3 of 3

Thread: Compare two columns to sheet3 based on condition

  1. 09-14-2013, 02:24 AM #1
    vengal
    vengal is offline
    Junior Member
    Join Date
    Sep 2013
    Posts
    1
    Rep Power
    0

    Compare two columns to sheet3 based on condition

    In the workbook there are 2 sheets
    1)Postawardlog and 2) budget posted in EIS
    Our task:
    ACCOUNT in sheet1 and Projectid in sheet2, TOTAL in sheet1 and Amount in sheet2 are columns which needs to be compared. We need to display o/p in sheet3 for only which are not matching. Please see the project1 word document attached for details. Please post me the macro code or email me at vengal19@gmail.com
    Please download the link from below. project1.xlsm

    https://www.dropbox.com/s/4mh12roxqh8skhw/project1.xlsm
    Reply With Quote Reply With Quote
  2. 09-14-2013, 02:51 AM #2
    rollis13
    rollis13 is offline
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Cross-post:
    Compare two columns to sheet3
    Compare two columns to sheet3 based on condition
    Compare two columns to sheet3 based on condition
    Reply With Quote Reply With Quote
  3. 09-14-2013, 11:15 AM #3
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi vengal,

    Welcome to ExcelFox!!

    Please read the message to cross posters in my signature.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Icon set based on another cell value or condition.
    By devpp in forum Excel Help
    Replies: 5
    Last Post: 08-14-2013, 10:01 AM
  2. Compare Date Columns In Excel And Pull The Latest Date
    By marentette010 in forum Excel Help
    Replies: 1
    Last Post: 07-31-2013, 11:56 PM
  3. VBA Program to Compare 4 Columns in Excel (Required)
    By vijaysram in forum Excel Help
    Replies: 11
    Last Post: 06-26-2013, 10:53 AM
  4. Chosing Attachment Based On Condition Before Sending Mail In Outlook
    By jja082 in forum Excel Help
    Replies: 4
    Last Post: 03-01-2013, 10:48 PM
  5. Formula Based On Condition
    By Aryan063007 in forum Excel Help
    Replies: 4
    Last Post: 10-09-2012, 10:37 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
  •  

Forum Rules