0
No, it is possible to sort on more than one column, which is used for sorting things within groups, like firstnames with surnames, or sales within months.
Emmanuel McKenzie
Wiki User
∙ 6y agoData can be sorted by a single column or by a combination of columns. You can use a Custom Sort to decide what way you want the data sorted. That can be by one or more columns.
Add your answer:
Earn +20 pts
Is it true that data can only be sorted by a single column (In Excel)?
If you only have a small amount of data, then it could be stored in a single column if appropriate.
How can you filter a report to include only transactions in a given wee?
It depends on what kind of program the data has been stored on. If on a spreadsheet, you would use a separate column for dates, and sort on this column. (Remembering to include the whole of the data, or only the date column would be sorted, leaving the rest of the data out of position.)
Can Data can only be sorted in ascending order.?
No, it can be sorted either in ascending or descending order.
Can Data only be sorted in ascending order?
No, it can be sorted either in ascending or descending order.
Can only be sorted in ascending order?
There is nothing that can only be sorted in ascending order - unless the sorting is being done as the data are being generated.
What is a MRF?
An MRF is a Materials Reclaimation Facility, where recyclable waste is sorted and shipped to recyclers. It may be a single stream plant where only one waste stream is sorted, such as plastic or a commingled plant where waste direst from your bin is sorted.
What is a small MRF?
An MRF is a Materials Reclaimation Facility, where recyclable waste is sorted and shipped to recyclers. It may be a single stream plant where only one waste stream is sorted, such as plastic or a commingled plant where waste direst from your bin is sorted.
What is the difference between single column cash book and double column cash book?
In single column cash book only cash account is shown while in multi column cash book cash as well as bank account is also shown.
In excel 2007 if a have a column of names most of which are repeated can you build a formula that will look at that column and pick out each name once and place it in a different column?
In Excel 2007, the quickest and easiest way to accomplish this is to copy your data to a new column and apply the Remove Duplicates command.Given a column of data in column A.Click on A, the column heading.Press Ctrl-C to copy the column.Click on B, the column heading for the next column.Press Ctrl-V to copy the data from column A to column B.Click on B, the column heading.Click on the Data tab on the menu ribbon bar.In the Data Tools section, click on the Remove Duplicates button (continue with current selection).Observe that column B contains only one copy of each item from column A.If you want the list in alpabetic or numeric order, just sort column B.
Example for first normal form?
A relation is said to be in 1NF iff each arttribute of the relation is atomic i.e each column must contain only single value. basic rules for 1NF 1.eliminate duplicate column from the same table 2.create separate table for a gr. of related data and distinguish each row with a unique column or set of column
How do you change a column chart ao a pie chart?
Not all column charts can be converted to pie charts. It can only be done if the column chart has a single series, as a pie chart can only have one series. If the column chart has more than one series, only one series will be shown when it becomes a pie chart. If the column chart has a single series then going to the Chart menu and choosing Chart type will enable you to change it.
What does the unix command 'comm' stands for?
comm is stand for - finding what is common. The comm command reads two sorted files,file1,and file2,to produce a three-column output. The first column gives lines that exist only in file1; the second column displays lines that exist only in file2; and the third column shows the lines common in both files. //hop helpful thanks
