Results 1 to 5 of 5

Thread: Extracting Unique Data

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14
    Hi

    It would be appreciated if you could help me again.

    I now need to compare column A & E, and need to compare col E to col A and to extract data in Col A that does not appear in Col E

    Your assistance in this regar is most appreciated

  2. #2
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    13
    Code:
    IF(COUNTIF($E$2:$E$18,A2)=0,A2,"")

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. Replies: 6
    Last Post: 06-01-2013, 03:24 PM
  3. 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. Replies: 2
    Last Post: 01-07-2012, 12:11 AM

Posting Permissions

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