Auto sort column - within the same column in a spreadsheet?
Hello,
I don't know if it is possible but I want to make a list in column A but as I add new stuff to column A at the bottom I'd like Column A to auto sort - including the columns associated with it.
I don't want column D to be a sorting of what is in Column A - I want the column where you enter stuff to auto sort itself.
I have no idea if this is possible. It isn't critical - just curious.
For context we are making a spreadsheet
Column A is restaurant names
Column B it the type
Column C is the address
Column D is a rating from someone in my group
Column E is a rating from someone else in my group
Etc.
We are just making a list of places we've tried and giving them an average score.
As we try new restaurants we'd like to add them to the column A and then have it auto sort alphabetically.
Thanks.
[link] [comments]
Want to read more?
Check out the full article on the original site