This is helpful, can you help me understand how to make filter "catergories", I don't know how to explain. In my table, I have three locations, in another cell column I have number 1,2,3. The different locations go with the numbers, so like London in line with 1, London in line with 2, Madrid in line with 1, Madrid in line with 2 2 and so on. How can I make a filter for each region so that it will be like Madrid 1, Madrid 2, Madrid 3?
Hi, thanks for the video. I could only add the filter funnel icon to one column. Nothing I did would add this to my other columns. Not sure what to do. Thank you!
hi, i need your help please, i have a list of products for my business and i need to convert a new sorted list by text. and i want that one table i could change it and the other one i would be sorted by text so my employees could see the sorted one, do you have any idea how to do it, thank you very much
Great Video. Do you have any information about when they might add this basic function of sorting by multiple inside a savable view? Seems kind of broken without it. Thanks.
@@ProlificOaktree I’ve not found any way to sort by multiple in a saved view. Like sort by Price THEN alphabetical by name. Sorting using the filters at the top of a column blocks nested sorts.
@@ChrisPurser Oh, I see what you mean. Not a "view" per se, but you could use the FILTER or QUERY functions if you just want a dynamic list but you can't add to it.
@@ProlificOaktree thanks. I guess I don’t know what is meant by Query Functions and I guess I don’t really need to add to it. I was just looking for a SAVE concept after having set all the sorts I wanted. Seems only a single sort is savable. 😞
Re: multiple sorting criteria with filters - am I missing something when you say you can't do it? You just did it, in the video: by sorting first by order date and then category, the end result is rows sorted by category and within those categories, sorted by order date. If you did it in the opposite order, you would get them sorted by date and within the same date, by category.
SORT is built to accept multiple levels. If you try with FILTER, you'd have to remember what you did last and it would be gone if you filtered another way. SORT keeps the multi-level priorities that you give it.
I have a sheet with images inserted in one column, but nothing I've tried keeps the correct image with its corresponding data when the sheet is sorted. The images seem to be randomly placed, and some end up stacked. Any ideas? (I need step-by-step, if possible. Thanks in advance!
Really like your way of teaching. Not rushed, calm, clear, knowledgeable. Have subscribed.
Awesome, thank you!
That was extremely helpful, thank you for sharing.
Glad you liked it!
Very helpful overview - lots of things I had forgotten!
Since I learned to use the Query function, I hardly ever use anything else.
Yeah, I think anyone who took the time to learn it would just want to use it all the time. I miss it when I have to use Excel.
For some reason I had trouble using drop down values as criteria. But then I got there and would not have without your video. Thank you!
Love to hear it, glad I could help!
Superb style, pace and presentation - thank you very much
Glad you liked it!
This is helpful, can you help me understand how to make filter "catergories", I don't know how to explain. In my table, I have three locations, in another cell column I have number 1,2,3. The different locations go with the numbers, so like London in line with 1, London in line with 2, Madrid in line with 1, Madrid in line with 2 2 and so on. How can I make a filter for each region so that it will be like Madrid 1, Madrid 2, Madrid 3?
Hi, thanks for the video. I could only add the filter funnel icon to one column. Nothing I did would add this to my other columns. Not sure what to do. Thank you!
hi, i need your help please, i have a list of products for my business and i need to convert a new sorted list by text. and i want that one table i could change it and the other one i would be sorted by text so my employees could see the sorted one, do you have any idea how to do it, thank you very much
Great Video. Do you have any information about when they might add this basic function of sorting by multiple inside a savable view? Seems kind of broken without it. Thanks.
That is a feature of the filter views: ua-cam.com/video/YiQmftRD6sw/v-deo.html
@@ProlificOaktree I’ve not found any way to sort by multiple in a saved view. Like sort by Price THEN alphabetical by name. Sorting using the filters at the top of a column blocks nested sorts.
@@ChrisPurser Oh, I see what you mean. Not a "view" per se, but you could use the FILTER or QUERY functions if you just want a dynamic list but you can't add to it.
@@ProlificOaktree thanks. I guess I don’t know what is meant by Query Functions and I guess I don’t really need to add to it. I was just looking for a SAVE concept after having set all the sorts I wanted. Seems only a single sort is savable. 😞
Re: multiple sorting criteria with filters - am I missing something when you say you can't do it? You just did it, in the video: by sorting first by order date and then category, the end result is rows sorted by category and within those categories, sorted by order date. If you did it in the opposite order, you would get them sorted by date and within the same date, by category.
SORT is built to accept multiple levels. If you try with FILTER, you'd have to remember what you did last and it would be gone if you filtered another way. SORT keeps the multi-level priorities that you give it.
Hi, is there a reason why filters don’t work on data that came from ImportRange function?
Because it's really only one value...sort of...Try wrapping the IMPORTRANGE function inside a FILTER function.
Thank you! This helped me.
You're welcome!
I have a sheet with images inserted in one column, but nothing I've tried keeps the correct image with its corresponding data when the sheet is sorted. The images seem to be randomly placed, and some end up stacked. Any ideas? (I need step-by-step, if possible. Thanks in advance!
Use the IMAGE function instead of copy paste
Is it possible to Sort or Filter data on a Protected Sheet?
Yes, it won’t make a difference.
thank you sm!!!
Welcome sm!
I think it isn't possible to multi-column sort on a Filter. Dadgummit!
Yeah, you've gotta do that with the FILTER function or just sort instead of filter.