#1
|
|||
|
|||
Multiple Column Data Comparison
Afternoon, very new to excel so apologies if this is simple.
I have a large amount of names in a number of columns. Is there any way I can organise them to show which columns they appear in and which one they don't? E.g. to see whether customers have been traded with in my business in particular months. Cheers Chris |
#2
|
||||
|
||||
Need more information. Would be very helpful if you uploaded a sample workbook that is representative of your actual file. Then, manually, prepare a sample solution based upon your example.
|
#3
|
|||
|
|||
It looks like you have a single row for customer, and a column for every month. This means, that you change the design of your table every month! And when you want to create some reports based on this table, then you have to edit them also in every month!
Instead consider more database-like design. You will have a table with columns like Customer, Month, Value (Month being a date really - e.g. 1st of month - formatted like "yyyymm"), where you enter your data. Then you can design report sheets, which read info from this table, and display it in any form you'll need. And/or you can set autofilter on for data entry table, and add some SUBTOTAL formulas above your data entry table to calculate sum's or count's from filtered rows in data entry table. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying data in a column to another column | Peace Freak | Excel | 2 | 04-28-2017 12:31 AM |
Read multiple xml files in excel - Column names and Tag - Column alignment | sumshen | Excel Programming | 0 | 04-17-2017 12:55 AM |
need help! broken column & bar chart for multiple categories of data | elguapoyo | Excel | 0 | 01-23-2017 08:51 PM |
How to convert multiple xml data in xl column to xl data | vivekanand.p | Excel Programming | 0 | 01-28-2016 08:13 AM |
column of data referenced to multiple grids on another sheet | zorniac | Excel | 1 | 11-15-2013 10:19 PM |