# Tagged Questions

**0**

votes

**2**answers

42 views

### How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data:
A B C D
---------------------
2 1 0 2
3 2 1 4
5 3 3 6
7 5 6 8
11 8 10 10
...

**0**

votes

**3**answers

58 views

### Excel filter duplicate values in column A and filter out rows which have column C blank

Total n00b here.
How to filter duplicate values in column A and filter out rows which have column C blank.
I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next ...

**0**

votes

**1**answer

30 views

### How to calculate occurrences of some word in table

How can I calculate how many times occurrences any of these "value"
Column
for example I need:
N 97 5
N 72 7
N 83 22
N 70 3
N 76 8
Z 34 7
N 85 2
...
...
...
and sorted ...

**0**

votes

**3**answers

317 views

### How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows?
For example:
...

**2**

votes

**0**answers

170 views

### Excel 2013, can data be re-sorted automatically?

Is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically ...

**1**

vote

**2**answers

118 views

### Excel compare cells in columns A and B, show in column C cells only unique to column A

I know there's a formula for this in Excel but I can't get it right.
I've got a list of 7000+ names in column A, and a list of 4000+ names in column B. Some are duplicates, appearing on both column A ...

**0**

votes

**0**answers

201 views

### Using VBA to sort cells to match the values in an adjacent column

What I would like to do is write a macro that sorts the values in the range B3:D9 on the left side of the linked image to produce the intended result (shown on the right side). For every value in ...

**0**

votes

**1**answer

143 views

### Unable to sort selected cells within the Table in Excel 2013

I created a Table in Excel 2013 but I want to sort only selected cells. The table range is A1:I200 but I only want to sort A150:I200. I tried selecting the cells, right click, sort, it sorted the ...

**0**

votes

**1**answer

122 views

### Grouping and sorting rows in Excel based on single column

I have a list of families I need to sort by last name in column A. You can see that each child in the family has its own row. The problem is that when you apply sort by column A descending, it does ...

**-4**

votes

**1**answer

337 views

### how do you ignore empty cells?

I'm using this function to rank data:
=SUMPRODUCT(($B$2:$B$11>B2) / COUNTIF($B$2:$B$11,$B$2:$B$11&"")) + 1
This version assigns 1 to the highest value
and sequentially increasing ranks to ...

**0**

votes

**1**answer

2k views

### How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...

**2**

votes

**2**answers

161 views

### Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X
Example:
A B C
1 1 X=7
2 3
3 5
4 8 ANS=5
Do you have any smart ideas for this problem?

**2**

votes

**0**answers

660 views

### Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...

**-4**

votes

**1**answer

288 views

### Find n rows in spreadsheet with lowest values in one column [closed]

There are two columns, say, A & B. Total 50 numbers are inserted in Column A; i.e., A1..A50 (numbers can be same like 20 can come more than one time or up to 50 nos.). In front of every row of A1 ...

**12**

votes

**2**answers

2k views

### Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...

**0**

votes

**2**answers

3k views

### Is there a dynamic sorting feature in Excel 2007/2010?

I have a task list spreadsheet that I maintain. Each task is given a ranking based on number of days until due date, weighted by high, low, or medium priority. The ranking is automatically calculated, ...

**0**

votes

**2**answers

3k 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

**1**answer

73 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

**1**answer

66 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

**1**answer

77 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

**1**answer

1k 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

**4**answers

2k 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

**2**answers

648 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

**2**answers

250 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 ...

**3**

votes

**2**answers

245 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

**2**answers

86 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 ...

**0**

votes

**5**answers

11k 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

**1**answer

105 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

**2**answers

132 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

**1**answer

368 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

**1**answer

935 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

**3**answers

903 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

**1**answer

411 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

**2**answers

228 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| ...

**2**

votes

**1**answer

3k 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

**1**answer

177 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 ...

**0**

votes

**1**answer

499 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

**1**answer

154 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

**1**answer

92 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

**2**answers

22k 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

**3**answers

2k 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

**2**answers

834 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

**3**answers

2k 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 ...

**10**

votes

**1**answer

16k 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 ...

**1**

vote

**3**answers

2k 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

**2**answers

334 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

**3**answers

6k 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

**1**answer

1k 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

**1**answer

72 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

**2**answers

432 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 ...