8 posts tagged with excel and sorting.
Displaying 1 through 8 of 8. Subscribe:

Excel: Is it possible to sort by an arbitrary list?

I have a list of 625 English words, translations in a bunch of languages, and what-not in a giant excel file. We'll call that excel file "the Data." The Data is in alphabetical order. I also have a separate list of those same English words in a different order. Is there a way to sort the Data so that it's in the same order as my new, non-alphabetical list? [more inside]
posted by sdis on Jul 7, 2013 - 6 answers

Panning for email addresses

How do I sort the (potentially) real email addresses from the garbage data in Excel 2003? [more inside]
posted by FatherDagon on Jul 29, 2011 - 4 answers

Please default to column headers, Excel.

How do I get Excel 2007 default to using column headers when I'm sorting? [more inside]
posted by Dolley on Apr 12, 2011 - 8 answers

I Know What I Know.. But How Do I Know What I Don't Know?

Excel Filter: I have a long list of file names in numerical order in an Excel spreadsheet. I need to know what numbers are missing, so I can track down the related files. Is there a quick and (relatively) painless way of doing this without having to sift through all the numbers manually?
posted by Philby on Mar 24, 2011 - 5 answers

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows?

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
posted by bottlebrushtree on Mar 5, 2011 - 7 answers

How to keep lists sorted both horizontally and vertically?

Sorting and keeping track of my research: is Excel the best solution? [more inside]
posted by pipti on Jan 27, 2011 - 13 answers

Excel sort for relative placement

I'm trying to implement a sorting algorithm in Excel known as "relative placement." Here's the setup: [more inside]
posted by philosophygeek on Dec 17, 2010 - 2 answers

How to get Excel to convert dates from European to American

How do I convert European dates to American in Excel? [more inside]
posted by jdruk on Feb 25, 2008 - 3 answers

Page: 1