Tagged Questions
0
votes
1answer
19 views
In Excel, How to sort a column and keep respective values in other columns
How do I sort a column according to ascending values in excel, while keeping the respective initial value in the other columns on the same row?
Column A shows the name of a subject. Column B shows a ...
0
votes
1answer
25 views
Excel rearrange data and sort
i have a table in excel with data in this format (with alot more data):
date source data1 data2
1.2.3 1 767 888
1.2.3 2 543 444
2.2.3 1 557 333
2.2.3 3 576 777
It ...
0
votes
1answer
38 views
How to sort an Excel column using the following characters
I have a column with letters W and E following numbers, i.e.
4e
5w
6w
7e
7e
, and I want to sort the column into e and w.
Any help would be appreciated.
0
votes
1answer
40 views
Correct sorting after text to columns in EXCEL
I have some data in which one column represents the Days of Operations, as below:
-------
Days
-------
15
7
1234567
etc.
I want to "break" the column (via text to columns option in the Data tab of ...
0
votes
1answer
75 views
How can I sort a list of numbers, by its last 3 digits in Excel
I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...).
Each one of the nubers if have 8-9 digits and I would like to sort this column by its ...
-4
votes
4answers
103 views
Finding values that only appear once in column
I have 4 columns and ~10K rows. I wonder whether it is possible to extract the rows where the value in column (A in my case) occurs only once.
I don't want to filter out the duplicates, just the ...
0
votes
2answers
159 views
Why do I get an #REF! error after sorting?
In my workbook I use this formula:
=INDEX('G:\Manufacturing\WH\EXPORTS\Scanning_Reports [ScanningReport.xls]Sheet1'!$D$1:$D$65536;AB3)
It works fine but when i try to sort the data i got a #ref! ...
1
vote
2answers
84 views
How can rearrange my columns to rows in Excel?
It is a bit complicated to describe in words, but I am making a literature review and I need to map how often certain theories are used within certain themes or topics. I currently have a table like ...
0
votes
0answers
170 views
Excel VBA macro to sort sheets in a custom order?
I have a workbook with over 20 sheets. Each sheet contains an error type, and a list of records with that error. These workbooks are produced elsewhere and then sent to me.
I want to sort the sheets ...
3
votes
2answers
71 views
how can I sort duplicate values in excel without repeated it sequence
i want the excel sort the values A to Z first then take the duplicate values to sort it again below A to Z like the following:
if i have the values a,c,b,e,d,a,c when i sort it a to z it's look like ...
1
vote
2answers
62 views
sort numbers in excel10
this is a sample of my movie list as you can see 61 is at the top and 8mm at the bottom
please explain how i can have 1 at the top and 3000 at bottom
61
.45 2006 dvd
10 1979 dvd
10 items or less 2006 ...
1
vote
2answers
902 views
My excel spreadsheet won't sort/alphabetize properly
I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...
2
votes
1answer
66 views
Tagging or defining automatically in an Excel or Libre office spreadsheet?
I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
-1
votes
2answers
106 views
Recomposing data structure
I've a worksheet of 35k rows of the kind in the first table below that I want to reshape as in the lower table.
So, I want to reshape this data in a way to get all the people within a specific ...
1
vote
1answer
226 views
Automatic sort for excel worksheet
I want to create a to-do list in Excel that automatically sorts the to-do entries in a list, in order of ones to do first (closest deadlines). I would also like a section that shows the tasks for ...
1
vote
1answer
522 views
Sorting two non-adjacent columns without affecting any other column
I have two different columns on Excel.
I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
0
votes
3answers
487 views
Excel 2010: Do sortable tables support sorting within multiple columns?
In Excel 2010 (and perhaps recent versions), you can select a range of data and insert a table over it that adds user-friendly sorting capabilities to the data. However, it appears that it doesn't ...
1
vote
1answer
231 views
Microsoft Excel 2003 - Merge by Column
I'm trying to merge two excel files, here is the structure of the files:
[A] [B]
I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
5
votes
2answers
183 views
How do I expand columns of items in Excel so that each item is on its own line?
I have this:
-----A-----|-----B-----|-----C-----
1|cherry |apple |banana
2|kiwi |banana |cantaloupe
3|peach |grape |peach
4| |peach |watermelon
5| ...
1
vote
1answer
1k views
Excel: How to treat multiple lines as one while sorting?
I get a XLS-File as a database report. The File is in the following format:
| Customer | Name | ... | Orders
1 | 6 | ... | ... | 1234
2 | | | | 4567
3 | | ...
0
votes
1answer
154 views
How do I sort in Excel 2007 but do not go to the top of the list?
How do I sort in Excel 2007 but do not go to the top of the list? I have a filtered set of data many rows long. However, when I am deep in the list, and select to change the sort by method on one of ...
1
vote
1answer
328 views
Lookup and return value based on sub-string match
Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g.
Input
COL_a COL_b
name ...
0
votes
1answer
289 views
Filter rows with unique values on Microsoft Excel
I have got a set of rows in an microsoft-excel
column_a column_b column_c column_d column_e
r1 200 300 350 400 3
r2 200 ...
0
votes
1answer
126 views
Use Excel to select the most recent row from a CSV?
I have a CSV that starts with a date/time field and I need to import, and select the most recent row and refer to it in my formulas.
I'm experimenting with Pivot Tables, and just now Rank and ...
0
votes
1answer
66 views
Excel - Sort by x - 0000xx000000
I have a list in Excel that i need to sort. But i need to sort on number xx in the following format:
1234xx123456
3541xx548135
So if xx in the first row is 68, and the xx in the second row is 45, ...
1
vote
2answers
10k views
Excel Sort Numeric Column By Number
I have a column of integers in my spreadsheet, and the column is formatted as a number. Each cell inside the column is formatted as a number.
But I can't seem to sort them in numerical order - you ...
1
vote
3answers
966 views
Advanced sorting in excel
I have a data in excel in the format:
Description Name Percent
Always A 52
Sometimes A 23
Usually A 25
...
1
vote
2answers
392 views
How to copy lines in Excel file that contain a value from a list
Description
I have a CSV file with 6000+ lines in it. I have a list of about 300 words that each appear in only one row of the CSV file.
Problem
How do I extract only the rows that contain a word ...
4
votes
3answers
1k views
How to sort list-style numbers in Excel?
I have a column of "numbers" in Excel that I would like to sort as follows:
1.1
1.2
1.2.1
1.2.6
1.2.9
1.2.10
1.2.11
1.3
However, regardless if the cell's type is number or text, Excel sorts them as ...
9
votes
1answer
4k views
How to sort an Excel spreadsheet columns by row contents?
How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
0
votes
3answers
742 views
How to sort on hh:mm:ss (duration) in Excel
I have a column of data that represents duration, e.g. 33:15 - 30 minutes and 15 seconds; 1:05:00 - 1 hour and 5 minutes, etc.
If I try to sort it A-Z, then 1 hour gets sorted before 30 minutes.
Is ...
1
vote
2answers
221 views
Excel: Remove lines with duplicates in column B, based on data in Column A
I need to find duplicates in Column B; and then delete the entire line if the the value in Column A is the number 4. There are lines that need to be kept and have "4" in Column A.
A B
1, John
4, ...
0
votes
3answers
2k views
How do I line up two sets of data in Excel?
If I've got two sets of data, how can I line them up in Excel 2007?
For example, if one set of data has
Position Occurrences
8 3
11 1
17 ...
0
votes
1answer
341 views
Sort doesn't work properly for cells with references to other cells
I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table:
For instance, the value of the first cell in the ...
1
vote
1answer
64 views
Can excel organize my data into groupings?
First off, my data sample:
EZ LOADER 1
FAIRMONT MOBI 1
FARMALL TRACT 3
FORD 5
FORD 700 1
FORD F-150 1
FOUR DOO 1
FOUR WINNS 1
GENERAL 3
GENERAL ...
0
votes
2answers
293 views
Pull up Excel's Sort Dialog
I have to sort a protected sheet and need to perform the unprotect-sort-protect dance.
The problem is this way I'm duplicating (less than perfectly) Excel's own sorting functionality, with the ...
1
vote
1answer
538 views
Two Spreadsheets, Merge Data?
I was wondering what is the best way to merge two spreadsheets which have the name id's e.g:
One sheet has:
apple 5
dog 3
cat 2
Second sheet:
dog 4
apple 7
cat 3
I would ...
0
votes
1answer
2k views
Excel / VBscript: Need to sort columns with a header
I have a vbsctipt that opens an Excel(2007) document copies the used range from two sheets (minus the header on sheet 2) puts it all on 3rd sheet. I then need to sort that data using the header. I ...
0
votes
1answer
915 views
Autosort microsoft excel worksheet
Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?
1
vote
1answer
435 views
Other language Sorting(like hindi, not english) for Excel sheet column
How can I sort excel sheet column for other languages like hindi(not english)?
1
vote
0answers
248 views
Sorting in Pivot Table on how data is summarized, not just the value
Often I am creating pivot tables that summarize some count by some category. Let's say I am counting Yes/No responses by some category. I usually add the count field and display it as a "% of row", ...
2
votes
2answers
432 views
Excel 2003 Alphabetic Sort Order Is Not My Idea of Alphabetic
I have an Excel 2003 spreadsheet that I'm sorting on the first column, which is formatted as Text. The sort order is strange. Here's a "sorted" example. I've highlighted the anomaly.
120-BDXX
...
4
votes
3answers
10k views
Fixing the first row as sortable title in Excel 2007
I know this is super easy, I just couldn't find it.
I'd like the first row in an excel document to be the "title" field. I want that:
Whenever I scroll down, this row will remain fixed
I can sort ...
1
vote
4answers
7k views
How to filter an Excel column for entries matching a master list
The general question entails sorting a large Excel 2007 list to find entries that match smaller subset list.
I have a couple of ideas on how to approach the problem, but I lack the technical ...
