0
votes
2answers
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
3answers
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
1answer
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
3answers
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
4answers
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
2answers
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
2answers
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
2answers
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
2answers
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
5answers
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
1answer
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
2answers
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
1answer
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
1answer
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
3answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
2answers
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
3answers
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
1answer
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
3answers
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
2answers
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
3answers
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
1answer
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
1answer
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
2answers
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 ...