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
i would recommend you 'Format as a Table' (Home -> Styles -> Format as Table)
This will default to adding the drop down quick filters that make it easy to sort and filter the set of data. You could just add those quick filters (Data -> Filter) but by formatting as a Table does more. For example when you select a cell in the table you have the Table menu and you can change the name of your Table. And you can reference all the data in the table using that name. So if you call it DATA and the first column is Date then DATA[Date] will refer to that date column.
This will default to adding the drop down quick filters that make it easy to sort and filter the set of data. You could just add those quick filters (Data -> Filter) but by formatting as a Table does more. For example when you select a cell in the table you have the Table menu and you can change the name of your Table. And you can reference all the data in the table using that name. So if you call it DATA and the first column is Date then DATA[Date] will refer to that date column.