Results 1 to 8 of 8

Identify cells with same values from two columns

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    16

    Identify cells with same values from two columns

    In a spreadsheet, I have 2 columns:
    Column A contains the name of all the financial documents reports of our company.
    Column B contains the name of all the financial documents which my team has worked (these reports can be for both external clients as well as for our company)
    Ex:
    Col A Col B
    F1 F1
    F2 F4
    F3 F5
    F5 F6
    F11 F8
    e.t.c
    My task is to identify all the reports for which my team has worked. From the example, I should be able to extract the following report names: F1, F5

    Thanks in advance for all your help.

    Note: I am using MS Excell 2007 (Windows Platform)
    Last edited by streetcat; 01-06-2012 at 04:17 AM. Reason: Problem is solved :-)

Thread Information

Users Browsing this Thread

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

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