Column stats was new info for me. Always find something of value in your videos. I almost always place my data with about 5 blank rows above. Then freeze the rows, then use filters just like you demonstrated. The real benefit comes after adding Subtotal() functions within the blank rows, based on the filtered data. Stuff like Sum, Count, Min, etc. They always remain visible because of the frozen rows, and they respond to the current filter. Very useful! Learned that technique about 30 years ago.
Great video Scott. Thanks. 2 Questions left: 1. Did you use chapeters in this video and how can I see them in playing the video and 2. How do you make such video 's ? Which tools you use?
Column stats was new info for me. Always find something of value in your videos.
I almost always place my data with about 5 blank rows above. Then freeze the rows, then use filters just like you demonstrated. The real benefit comes after adding Subtotal() functions within the blank rows, based on the filtered data. Stuff like Sum, Count, Min, etc. They always remain visible because of the frozen rows, and they respond to the current filter. Very useful! Learned that technique about 30 years ago.
That's a great tip, Jack. Thanks for sharing!
Great video!
Couple of nice ones there Scott! Thanks again. 😁
Any time, Bill!
Great video Scott. Thanks. 2 Questions left: 1. Did you use chapeters in this video and how can I see them in playing the video and 2. How do you make such video 's ? Which tools you use?
Data cleanup and column stats are features that I wasn't aware of before. Thanks Scott.
You are very welcome, Ajay.
Thank you 👍
You bet!
Thanks sir
Welcome
Thanks
Welcome
More good sheet video
We need more and advance video of Google sheets, please upload