#1
|
|||
|
|||
matching names in column A with names in column C
I have a list of customers in column A and their sales in column B from 2013. I have the same data in columns C & D for 2012. Some of the customers in column A were not customers in 2012, and some of the customers in column C are not customers in 2013. I want one list that includes all customers, and produce sales for both years; if a customer bought in both years it would produce sales amounts in columns B & D; if just 2013 then only in column B and zero (or blank) in column D; if just 2012 then only in column D and zero (or blank) in column B.
I tried the LOOKUP function but it did not work; I do not know how to use the pivot tables. Any suggestions? |
#2
|
||||
|
||||
Post a sample sheet please, no picture
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Columns. How to move the left column so it's to the right of the 'right' column ? | Vit | Word | 9 | 11-21-2012 12:57 PM |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
Need to search a column for a macth and return a result from a third column | pdfaust | Excel | 2 | 02-03-2011 03:02 PM |