Hi, Debra. I learn so much from your presentations. I also remember to make my files more interesting if it is only for me. Thanks for sharing! Stay healthy!
Thanks, Jon, and I'm so happy to hear that! And you're right - we need to keep our own files interesting too, and they're a great place to try new things.
To show that data range's data in a table, use the new FILTER function (Excel 365) ruclips.net/video/OHHKhiqQKos/видео.html Or use an Advanced Filter (all Excel versions) ruclips.net/video/O1Od6KIHEd8/видео.html
You're right, it's easier to build a pivot chart, and my last video showed an example of that. The chart in this video works well on a dashboard, where it's easy to see the date range, and change it, with limited space required.
This is the first time I know how to use operators in SUMIFS --- with quotation marks and ampersand. Really helped. Thank you.
You're welcome, Alfred, and thanks for letting me know the video helped you!
Hi, Debra. I learn so much from your presentations. I also remember to make my files more interesting if it is only for me. Thanks for sharing! Stay healthy!
Thanks, Jon, and I'm so happy to hear that! And you're right - we need to keep our own files interesting too, and they're a great place to try new things.
very Good and helpful, thank you
You're welcome, Aslan, and thanks for your comment!
Instead of a graphical chart that shows those date ranges, is it possible to make another table that displays information from that date range?
To show that data range's data in a table, use the new FILTER function (Excel 365)
ruclips.net/video/OHHKhiqQKos/видео.html
Or use an Advanced Filter (all Excel versions)
ruclips.net/video/O1Od6KIHEd8/видео.html
Great and helpful , thanks for sharing .
You're welcome, and it's lovely to see a comment from you!
But instead of this we could use Pivot charts...it will be much easier
You're right, it's easier to build a pivot chart, and my last video showed an example of that. The chart in this video works well on a dashboard, where it's easy to see the date range, and change it, with limited space required.