+ Reply to Thread
Results 1 to 2 of 2

How to find a column in of numbers in another column

  1. #1
    Registered User
    Join Date
    10-08-2010
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to find a column in of numbers in another column

    Hi,

    Kindly go through the below stated situation:

    I have two columns of numbers, Data 1 column and Data 2 column.

    "Data 1" contains numbers that are present in "Data 2" but some numbers in "Data 2" column are unique which can not be found in "Data 1" column.

    Now, I want to know which numbers of "Data 2" column are present in "Data 1" and delete them from "Data 1" column.

    I have attached the sample.

    Kindly suggest me what should we do.
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: How to find a column in of numbers in another column

    hi Shouvik
    Welcome to the forum

    try this code
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1