Let's say I want Google Sheets to automagically sort some data, for example column C
.
How do I do that?
I know that I can manually sort data by right-clicking and selecting Sort data, but this is not what I'm looking for.
google sheetsgoogle-sheets-querysorting
Let's say I want Google Sheets to automagically sort some data, for example column C
.
How do I do that?
I know that I can manually sort data by right-clicking and selecting Sort data, but this is not what I'm looking for.
Best Answer
You can use the
sort()
function for that, but you have to have your data in one place, and an automatically sorted copy of that data in another place.For example, say I have Sheet1 with my data:
Then in Sheet2, cell A1, I would put this function:
This would show my data, but sorted by column C (the third column), ascending.