|
|
#1
04-28-2013, 10:42 AM
|
|||
|
|||
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? 
|
|
|
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 |
Windows 8 
Office 2013
Threaded Mode