Results 1 to 5 of 5

Thread: Extracting Unique Data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-01-2012, 02:48 PM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Extracting Unique Data

    I have data in Column A and in Column E from row 2 onwards.

    1) I would like to set up a formula in column F compare the data in Column E to Column A and where data exists in Column E, but not in Column A, I would like this extracted
    2) I would like to set up a formula in column G compare the data in Column A to Column E and where data exists in Column A, but not in Column E, I would like this extracted
    3) I would like to set up a formula in Column H or VBA code to compare column A to Column E and extract the numbers that are unique to both

    your assistance is most appreciated
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Move data from rows into columns for every unique value
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-13-2013, 03:02 AM
  2. Extracting Specific Line Of Data From Text File Using VBA
    By galang_ofel in forum Excel Help
    Replies: 6
    Last Post: 06-01-2013, 03:24 PM
  3. 10$ For VBA Code Split Data To Multiple Workbook Based On Unique Values In A Column
    By jamilm in forum Hire A Developer
    Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  4. Extracting Numeric Values From Alphanumeric Text
    By Safal Shrestha in forum Excel Help
    Replies: 3
    Last Post: 03-21-2013, 12:04 PM
  5. Generate A List of Unique Values / Unique Array
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 01-07-2012, 12:11 AM

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