+ Reply to Thread
Results 1 to 1 of 1

Comparing contents in 2 columns of pivote tavle & if contents found same then generate

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    Nashik
    MS-Off Ver
    Using Kingsoft Office
    Posts
    16

    Comparing contents in 2 columns of pivote tavle & if contents found same then generate

    Hi everybody,

    I have made 2 pivot tables. Both contents client's name in one of the column of two pivot tables.
    Suppose that column is "C". One pivot table is from row no.2 to 18. Second pivot table is from row no. 26 to 45.
    There is another column which is suppose column "D". Column "D" contains information regarding client mentioned in column "C".

    Now what I want to do -

    I want to compare the names in column C of both pivot tables. If the name matches then I will write in column E the contents of D otherwise its blank.


    C D E
    aaa 7/2/2013
    bbb 6/5/2013
    ccc 5/9/2013
    ddd 6/7/2013
    eee 2/10/2013
    fff 10/4/2013
    ggg 8/5/2013



    ppp 5/9/2014
    qqq 4/3/2014
    rrr 9/1/2014
    zzz 12/15/2014
    aaa 8/2/2014
    fff 8/17/2014
    Last edited by Parag Chincholikar; 10-21-2014 at 05:41 AM. Reason: Typing error

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Code - Compare Adjacent Cells In two columns and clear contents when a match is found
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-03-2013, 06:22 AM
  2. Comparing contents in 2 columns
    By jswainson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2012, 08:21 AM
  3. Adjusting Range Contents Based on contents of Three other columns
    By VTHokie11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2012, 01:55 PM
  4. Replies: 2
    Last Post: 02-22-2012, 11:12 AM
  5. Comparing columns and copying contents
    By rota426 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-28-2008, 05:14 PM

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