# Tagged Questions

**2**

votes

**1**answer

31 views

### Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...".
For example: some email addresses are "test@test_user...". ...

**0**

votes

**2**answers

19 views

### Sort Excel Row Based on Values in Another Row

Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do.
I have a lot of spreadsheets where I have something like:
A|B|C|D|E|F...
...

**0**

votes

**1**answer

17 views

### Excel 2007. Data Tab is grayed out. Nothing on that Tab is available

I'm trying to sort a file to which I add rows daily. I usually have no trouble sorting, but from some reason all the items on the Data Tab are 'grayed out' and unavailable. Any idea what's caused ...

**0**

votes

**1**answer

43 views

### Sort & Ranking Functions in Excel for Time AND Number Values in one Column

I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...

**2**

votes

**2**answers

105 views

### Alphanumeric sorting in Excel

In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11?
Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've ...

**0**

votes

**0**answers

39 views

### Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like:
I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not).
I have checked for ...

**0**

votes

**2**answers

70 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

100 views

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

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 800 rows are ...

**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

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

207 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

327 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

220 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

191 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

185 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

443 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

252 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

760 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

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

**13**

votes

**2**answers

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

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

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

81 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

69 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

81 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

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

688 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

308 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

288 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

87 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

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

107 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

134 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

402 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

967 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

960 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

422 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

238 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

178 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

528 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

157 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

93 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

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

887 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

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