Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2019, 07:03 AM
Croakes92 Croakes92 is offline Multiple Column Data Comparison Windows 8 Multiple Column Data Comparison Office 2010
Novice
Multiple Column Data Comparison
 
Join Date: Jul 2019
Posts: 1
Croakes92 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-23-2019, 02:15 PM
Alansidman's Avatar
Alansidman Alansidman is offline Multiple Column Data Comparison Windows 10 Multiple Column Data Comparison Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 07-23-2019, 11:59 PM
ArviLaanemets ArviLaanemets is offline Multiple Column Data Comparison Windows 8 Multiple Column Data Comparison Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Column Data Comparison 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
Multiple Column Data Comparison column of data referenced to multiple grids on another sheet zorniac Excel 1 11-15-2013 10:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft