Results 1 to 5 of 5

Thread: Find Missing Values By Comparing Two Columns / Find Missing Data In Column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-05-2013, 08:55 AM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14

    Find Missing Values By Comparing Two Columns / Find Missing Data In Column

    I have a workbook containing several sheets. I would like to compare the account numbers on Sheet1 Col C with sheet imported data Col A

    I would like a formula in sheet 1 Col F to compare the account numbers on sheet1 Col C to sheet "imported data" Col A and where there is an account number on sheet "imported data" Col A and this does not appear on sheet1 Col C, then to indicate the account number in Col F and the value in Col G

    I would also like to compare imported data Col A with Sheet1 Col C and to do a similar formula in Sheet imported data Col D and indicate the value in Col E
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Userform problem [Message box for missing entry in opt and chk button]
    By ranthrave in forum Excel Help
    Replies: 8
    Last Post: 05-21-2013, 06:34 AM
  2. Check for Missing Attachment and Subject in Outlook
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. Find Last Used Row In Column
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 06-04-2012, 07:40 AM
  4. Find duplicate values
    By excel_learner in forum Excel Help
    Replies: 4
    Last Post: 10-24-2011, 12:10 PM
  5. Missing MSComctllib
    By Rasm in forum Excel Help
    Replies: 3
    Last Post: 04-05-2011, 09:45 PM

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