Forum Discussion
Excel
I would like to filter a list of banking transaction by date, and category. Column C is my date column. Column G are the categories. I have defined my transactions by category by assigning a numerica...
If data looks like this
it's better to transform it to table. The only important point you shall have headers for all columns. With that stay on any cell within the range and Ctrl+T. Result will be like, and additionally you may add slicer which works the same way as filter
and you have a lot of options to filter dates
Similar could be done on range, only without slicers, but Table is more suitable.
As for ###, - just make column wider, if only here is not negative time.