Forum Discussion
Product Count and Number Sold
I have a series of Excel worksheets in a single workbook that I create every month to track sales of products so I have columns for ITEM purchased and QUANTITY which is always one. There are up to 90...
WOW that works - THANK YOU very kindly for helping me.
I have created a Table with 3 years of data, how can I sort that to show data for each year instead of all 3 together?
Peter Bowen
I have created a Table with 3 years of data, how can I sort that to show data for each year instead of all 3 together?
Peter Bowen
In addition to the suggestions by mtarler for sifting and sorting after making this data into an official "Excel Table," there are within Excel multiple ways to extract data for reporting by year (or other time periods). I mentioned the Pivot Table in an earlier post; that is a technique that many find VERY valuable for summary reporting. There are also many YouTube videos that show how to use Pivot Tables.
If the data you are working with are not confidential, you could post a copy on OneDrive or GoogleDrive, with a link pasted here that grants access. Then mtarler or I could offer more specific suggestions.