answersLogoWhite

0

Copy the formulas and in the column next to them, use the Paste Special option and choose values. It will put the actual values into the cells. You can then sort your data based on the column of values.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

How do you sort linked data in excel?

You are able to sort linked data within any Excel document. If an error does occur check each columns formula so there Is agreement.


Why do you use Sort Data function in Microsoft Excel?

The sort feature allows you to look at the same data in different orders depending upon what information you seek. Excel allows you to sort by date, sort by text or numbers, sort by multiple columns, like listing values from highest to lowest or names in alphabetical order.


How do you sort a few columns based on one column's values from low to high?

What you need to do is select all the data. Normally when doing this, the first column of the data you selected acts as the key to sorting it. So what you need to do next is to go to a Custom Sort and select the column to base your sort on. Then you can do it on a different column. That will work. When values change in Excel it does not automatically sort them again like in a database, so you will need to redo the sort occasionally. You could set a macro up to do that for you.


How do you sort alphanumeric data like P15-033-1 in excel?

To sort alphanumeric data like "P15-033-1" in Excel, first ensure the data is in a single column. Select the column, then go to the "Data" tab and click on "Sort." In the sort dialog, you can choose to sort by the column containing your alphanumeric data, and select either "A to Z" or "Z to A" for the desired order. Excel will sort the data based on the alphanumeric characters, treating numbers and letters appropriately.


Is a formula and a function the same?

An Excel Function is a instruction to excel to perform some built in task or calculation.E.g. The function SUM(A1:A10) tells Excel to sum up all the values in cells A1, down to A10 and put the result in the cell where you typed it.A formula is an expression that produces a result and may include functions.E.g. A1+A2 tells Excel to sum the values in cells A1 and A2 only.Another example of a formula is A1+SUM(A2:A10)Both formulas and functions must be preceded by the equals sign for Excel to understand them.A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions.All formulas must start with the equals sign.=1+2+3A function is a piece of code designed to calculate specific values and are used inside formulas. Functions to sum values, calculate a trigonometric cosine, and to calculate the current time are built into excel. Additional functions can be defined using Visual Basic.Functions are typed alongside parenthesizes, where in the arguments if any are listed in between. To use functions in a formula, for example=COS(3.14) will return the calculated cosine.=NOW() returns the current time.=SUM(1+2+3) *2 will multiply the sum by 2A formula is any equation with a subject; e.g. y = 3x + 4.A function uses a formula that produces a single value y for every valid subject x.


How do you sort in Microsoft Excel?

Highlight the cell range you want to sort and click on the sort button. For Excel 2007, it is on the Home menu ribbon in the Editing section (on the right side of the ribbon).


How do you calculate top 10 using excel?

The easiest way to find the top ten values in a list is to sort the list from highest to lowest and select the top ten cells.


How do you order numbers in excel?

Highlight the cells you want to sort and click on the sort button.


How can find top 10 performers in MS-Excel?

Quick and dirty I will do in two steps first rank based on the criteria then sort based on the ranking or lookup to the first 10 position L


What XSL element can you use to sort or order your XML data?

Assuming "XLS" means MS Excel, you can import your XML data to Excel, then filter or sort as desired.


How do you sort out excel typing errors?

If by "sort out," you mean find and correct, then use the spell checker.


Can you sort files in ascending and descending orders?

no only data can be sort from the excel sheet.. not in the file