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
Bookmarks