Indeed! It sorts them alphabetically because they're strings. One way to sort them by the numbers is to add a virtual number column and sort with that, e.g. to sort the list "Product 1, Product 2, Product 3, etc." in descending order, you can use this formula construction: =SORT("Product "&SEQUENCE(20),SEQUENCE(20),FALSE)
your videos are super helpful, thank you. Q: what is the best way to “attach” the row count numbers to the full row or make them IDs for sorting/filtering?
TQ MR BEN COLLINS, I really love all your works in Google Sheets. Your presentation is SUPERB!!!! I always follow your tutorial, presentation and with this You Tube Channel it is really awesome. I really appreciate your efforts. Thanks again .
This is awesome!!! Thank you sempai!! I hope youll do also ultimate guide for Google Query! like the other syntax I could add in where clause, label and etc.
Just one problem with the 'string before' sequence - it won't sort correctly. Is there some way of numbering as 'Product 01'?
Indeed! It sorts them alphabetically because they're strings. One way to sort them by the numbers is to add a virtual number column and sort with that, e.g. to sort the list "Product 1, Product 2, Product 3, etc." in descending order, you can use this formula construction:
=SORT("Product "&SEQUENCE(20),SEQUENCE(20),FALSE)
your videos are super helpful, thank you. Q: what is the best way to “attach” the row count numbers to the full row or make them IDs for sorting/filtering?
TQ MR BEN COLLINS, I really love all your works in Google Sheets. Your presentation is SUPERB!!!! I always follow your tutorial, presentation and with this You Tube Channel it is really awesome. I really appreciate your efforts. Thanks again .
You're welcome. Thank you!
This is awesome!!! Thank you sempai!! I hope youll do also ultimate guide for Google Query! like the other syntax I could add in where clause, label and etc.
You're welcome! Check out the QUERY function playlist: th-cam.com/video/iWi3nL5MPK4/w-d-xo.html
This is the first time I am seeing a Public Video by Ben. Great!
👍
very good video!
Glad you liked it! Thank you
You secured another deserved subscriber with this foundational tutorial, thanks for sharing!
You're welcome. Thanks, Stephen!
Absolutely love all your work and learned tons from your website and newsletters over the years. Thanks for sharing all that knowledge 🤗
You're welcome. Thanks for your support! Cheers
Amazing as always!
Thanks, Marc!