The tag has no wiki summary.

learn more… | top users | synonyms (1)

11
votes
3answers
1k 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
0answers
180 views

Changing default sort order in Windows 7 desktop search

If I do a search (usually, I'm looking for an email), the results are presented in date-modified order by default I can do Sort By / More... and select Date Received, then Sort By and select Date ...
0
votes
1answer
51 views

how to delete a file after sorting in Linux

I have a huge file that needs to be sorted in Linux, for example: sort -k1,1 -k2,2n /dir/fileA.sam > /dir/fileA_sorted.sam Because I ran out of disk space, is there a way to delete the original ...
0
votes
1answer
2k 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
1k 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 ...
3
votes
1answer
184 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, ...
0
votes
1answer
63 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 ...
1
vote
2answers
698 views

How can I sort a long list of text alphabetically?

How do I sort rows of text alphabetically without using specialized third party software or plugins (like Notepad++/Word/Excel/et al)? I suppose what I'm perhaps asking is -- How do I sort rows of ...
0
votes
1answer
241 views

How can I permanently divide / separate files, folders, and shortcuts on Windows 7 desktop? [duplicate]

Basically I want to devote a flexible, visibly divided fraction of my screen to each type of icon visible on the Desktop (files, folders, shortcuts). What will I (or someone much more skilled than I ...
2
votes
3answers
227 views

weird filename sorting (bash, ls, sort)

Good day, everyone. I'm trying to feed my music to mplayer, like this: mplayer *, but getting wrong track order. Here's what I get with ls (as well as ls -1, ls -1 | sort), note the order of the ...
0
votes
1answer
57 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.
1
vote
2answers
162 views

How to manually sort files in win explorer?

I want to manually sort (drag and drop) my files in a certain (not in all) folders (win xp sp3). Is there any fix to do it ? If no - is there another file explorer with the feature.
5
votes
4answers
725 views

I need an easy way to 'google' through all my PDF files - anything like this exist? [duplicate]

Here is my scenario and system: System: Win-7, 64-bit. Scenario: Very simply, I have a folder on my dropbox account, titled \Papers. Within this folder, I have a lot of PDF files, and I have even ...
0
votes
1answer
66 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 ...
2
votes
1answer
195 views

Vim - sort blocks of code within blocks

Note: Can someone with 300 reputation please add the tag, "scss" to this question? I'd be very appreciative. My code (scss): .cinderblock { @include minwidth(); ...
0
votes
1answer
489 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
531 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
1answer
286 views

How to sort folders by last characters of folder name in Windows 7?

I have a stack of client folders with names like this: eastcoal 008 mee 022 orr 047 owaka 032 owen 025 powernet006 redpath 031 Normally this works, but sometimes I'd like to sort by the number. ...
1
vote
1answer
185 views

Office 2007: How to sort an Excel Table from within a Word macro

I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines: Dim Oxl_Sheet As Object Set Oxl_Sheet = ...
0
votes
1answer
419 views

UNIX command to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4

Need help with the UNIX command below to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4. (words are separated by white spaces) sort -t -k3 -k1 ...
1
vote
2answers
175 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
1k views

How to sort Windows 7 taskbar thumbnail previews?

Here is a screenshot of the list of windows I have stacked in my Windows 7 taskbar. This is just for Explorer, but similarly I have lots of stacked windows of other processes as well. Currently ...
-1
votes
1answer
554 views

(Some Program that lets me) Manually Sort Folders in Windows 7

I want to have some convenient way of remembering the order I put certain folders in, without being forced to rename them. Some of these folders may get deleted and new folders also get added, so ...
1
vote
1answer
123 views

Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature. These cells are colored differently, but the height doesn't stick with the ...
1
vote
1answer
341 views

How to view all my Google Chrome bookmarks, sorted by date?

I want to see a flat list of all my bookmarks in Google Chrome, sorted from the oldest one to the newest one. How can I achieve this ?
3
votes
2answers
177 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
84 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 ...
2
votes
1answer
133 views

How to output a partial or a number from a mataching in grep or ack

I have a text file demo.txt like below. This is a line with id (9) This (8) is another line with id (10) This is a line with id too 11 This line does nothing The file has some lines with id ...
1
vote
2answers
4k views

How to sort audiobook on iTunes?

I have a question that might seem dumb, but I didn't find anything on Google. How can I do to sort my audiobook tracks on iTunes? I have books with 4 or 5 CDs and I'd like them to appear as one. I ...
1
vote
1answer
766 views

Sorting by Date Modified in Windows 8

In prior versions of Windows I used to be able to sort my folders by date modified. If any files in those folders where added, removed, changed etc... the folder date would be updated. However, in ...
0
votes
1answer
128 views

Sort files based on their meta-data

At a local storage (ext3/ext4) I have thousands of files of various types. I need to sort them, however I can come up with the criteria to do so as long as it's possible to get an overview again. I ...
1
vote
1answer
153 views

Sort columns next to last column in Linux

I have multiple files: File 1 a 1 2 b 3 2 File 2 a 2 2 3 b 4 3 3 File 3 d 3 1 2 4 e 4 1 1 2 I'd like to sort the files according to the column next to the last column, after sort: File 1 ...
0
votes
2answers
84 views

How to add another sort tab for files in Windows?

I am working with a directory of PDFs which have been scanned from actual documents in a file cabnet. When viewing a folder's contents in windows by clicking the tabs above the information users are ...
0
votes
0answers
111 views

Arranging files in a folder Mac?

Im running Mac OS X Lion 10.8.2 and every time I boot up and go to my Applications folder the apps are all over the place, I proceed by arranging them alphabetically but later they are all over the ...
0
votes
1answer
223 views

sort du -sh by size in human readable

with the command du -sh * I get the summary of files in MB,GB, etc. If I use du -s * | sort -nk1 I get the summary sort by size. How I can get the summary sort by size in MB, GB, etc? Edit the ...
5
votes
1answer
111 views

Merge sorted lists

I have a few .txt files (in the same directory) that look like this: 123 carrot 50 apple 13 tomato 5 potato 2 pear and 100 carrot 10 apple 3 tomato 2 potato ...
2
votes
1answer
43 views

Sorting a list of files

Maybe am missing something but how do i sort in a descending order a list with this naming B7 B40 B41 B42 B8 B43 B20 B45 B53 B47 B48 B5 B6 sort -n does not sort the way i would like B5 B6 B7 and ...
0
votes
2answers
147 views

How do I sort command-line output?

I'm trying to use du to sort the output by filesize, but it doesn't looks like there's an option for that. Can I pipe it into another command to handle the sorting?
0
votes
3answers
6k 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 ...
1
vote
0answers
180 views

make “sort by” permanent for specific folder

I have a folder where I store all my web icons in .png and .ico format. I set view to large icons and sort by to date modified -> descending. When I save new icons in this folder from web, I drag ...
2
votes
1answer
101 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 ...
3
votes
1answer
74 views

Bug in sort or misunderstanding

Suppose I have this file b 10 foo a 10 bar a 2 bar I want to sort by the third colum, alphabetically. In case of ties, I want to sort by the second column, numerically. In the man page for the unix ...
2
votes
1answer
149 views

How to setup DLNA sorting

What is the best way using a windows server (as the source) to provide an easy to access listing of available videos for use by DLNA enabled television sets (specifically Samsung)? I've created ...
1
vote
1answer
201 views

Command-line sort and copy text files to one single file renders an error

I stumbled on question 217394 which explains how to copy files sorted alphabetically into one single file. Trying to implement the command myself rendered the following error message: The system ...
0
votes
2answers
535 views

Sort by bar dissapeared in Windows 7 folder explorer when viewing icons

Under Windows 7 sorting by thumbnail icon files takes longer, or a different path of clicks. I have to switch viewing files in details mode (select from the sorting bar) and then sort by date ...
2
votes
2answers
349 views

Excel mass add Data to existing sheet

I have an Excel Sheet with keeps track of Persons, who have gone to certain Activities. Now i want to add an Activity with hundreds of Persons, of which some have gone to others already. Then I want ...
1
vote
2answers
282 views

Sort each standalone line alphabetically

I want to sort some items in alphabetic order, but in a very specifc way. I have, for example, the following list, each item separated by comma: monkeys, big dogs, cats pineapple, banana, orange ...
7
votes
1answer
305 views

Windows 7 Recycle Bin sort by Date Modified

In the Recycle Bin, I sorted by 'Date Modified', but the result is not in the proper order. It was neither ascending nor descending. Other sorts (by Date deleted, size, item type) all work well. Does ...
5
votes
3answers
636 views

How to do custom sorting using unix sort?

I'm using unix sort to sort a comma delimited file with multiple columns. Thus far, this has worked perfectly for sorting the data either numerically or in alphabetical order: Example file before any ...