Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Function/Formula sorts data.
Hi all, I would like to know if there is any function/formula Excel provides to help in sorting data. For example, I have my data in Sheet1 as follows: A B Customer Product 1 234 16432 2 432 17094 3
how to sort in formula based cells
i have made a small excel file for cricket as it calculates the NET RUN RATE but the difficulty is that i want the net run rate column to sort according to largest to small with the team names column
Locking a formula or function to a cell
How do I lock a formula or a function to specific cells, so that even after I sort and these cells move to different rows, the formula or function still picks up on those specific cells?
Formula to sort items in one cell to 5 other cells using periods as the seperator?
I have information in a cell which contains words with periods to seperate each item. What formula can I use to sort the items into new cells? Thanks.
would like a formula to sort by the DaysUntil range if the number is less or equal to range
I have three ranges (Date, Event, DaysUntil) I would like a formula to sort by the DaysUntil range if the number is less or equal to range