Hello amazing people. I am trying to auto sort COLUMN B but when i do, all other columns C,D,E,F,G should auto sort and contain the corresponding data.
So i.e. if row3 goes further down, the same data on its right should follow! Is this possible?
I think there is a sort formula, but i can't sort it out (pun intended)!
Thank you!
Well, do you need a formula to be inserted somewhere else in the workbook? Or just need to sort your data. If this is the second case, just make an Excel Table (insert ->table on the ribbon) out of your data. See both sheets in the attachment in the second I deleted your sequence function and used another - then your table can grow as your needs grow. And for sorting you can just click on headers to select on which column you want to sort.
As for first option - see SORT and SORTBY examples in the attachnemt (the added sheet) Note (I left it untouched) that using formula you shall format column with dates as date format otherwise you will get day numbers from the beginning of excel calendar (some 40K+ values)
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks