Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

Sorting data by columns

Copper Contributor

I need to sort/filter data in my sheet and have the data to move with the sort

I need it to be done by location and then the next column to be done by name and another by date

it also keeps adding my header right under the one thats already there and moving the data where it shouldnt be

 

do i need to create a list to sort data? or what do i do

 

4 Replies

@Amber1023 

=SORTBY(A2:C11,A2:A11,1,B2:B11,1,C2:C11,1)

You can try SORTBY.

sorting data by columns.JPG 

will it keep all my other data in those rows with it when it sorts or do i do it by the column

or doin need to have it sorted/filtered left to right

@Amber1023 

Does the suggested formula return the intended result? If it doesn't can you give an example of your data and of the intended result?

This is the data i need in a table or sheet then i need to have it all added again for this current year so i can keep a running list going of every years data and view it next to each other as a comparison

how do i do this/make it


@OliverScheurich