When you want to apply a minor tweak to the document, it should not take long to Sort formula attestation. Such a basic activity does not have to demand additional training or running through manuals to understand it. Using the appropriate document editing instrument, you will not spend more time than is necessary for such a swift edit. Use DocHub to simplify your editing process regardless if you are a skilled user or if it’s your first time using a web-based editor service. This instrument will require minutes to learn how to Sort formula attestation. The only thing needed to get more productive with editing is actually a DocHub profile.
A simple document editor like DocHub can help you optimize the time you need to spend on document editing no matter your previous experience with such instruments. Make an account now and boost your productivity immediately with DocHub!
Hello, Im Chris Menard. Welcome to my Excel One Minute Video series. Todays Excel function is the SORT function. I have a list of employees, I made up from A1over into H. I want to do a sort, so Im going to do equal SORT. What do you want to sort? Im going to just pick the Last name through the Salary, just to keep this easy. The SORT function, there are your arguments. Notice theres four arguments, only the first one is required, so Im actually good right here. Lets see what we have. The SORT function is a dynamic array function. So I typed something in cell J2 and it filled in all the other data. Notice when I click another cell, if you look in my formula bar up in the top above column C, its greyed out until I clicked back in J2. Lets edit this and use a couple other arguments, comma, argument two is what sort index? I want to do this by Salary, which is the fifth column from what I have sorted. So 5, comma, how do you want to sort? Do you want to
