Results 1 to 4 of 4

Compare Columns From 2 Sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-24-2008
    Location
    Delhi
    Posts
    104

    Compare Columns From 2 Sheets

    Hello

    I have 2 Sheets Fee collection and Sheet2

    Fee Collection is Collection of All India Which is Handling by Me

    Sheet 2 is Also Fee Collection but they are Divide into 4 Zones i.e. North,South,East,West

    On Daily Basis i have Receive Sheet from All the 4 Zones, and i have to Check Whether the My Sheet (Fee Collection Master) is Map With Sheet2 (Received from Zones)

    I have to Check Through Column B to Column K

    Some Time i am Wrong and Some time Zones are Wrong , In that Case i Check The Details from Accounts and Correct our Reports

    Right Now, i am using "=" to Compare the Data

    Is there any Other Options to Compare data , If they Met it Shows "TRUE" Otherwise "FALSE"

    Thanks in Advance

    Hardeep
    Attached Files Attached Files
    Last edited by hardeep.kanwar; 07-02-2010 at 11:29 PM.

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