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

How might I randomise some spreadsheet rows once I populate it?

I'm developing a training resource for a client and the brief requires me to provide some spreadsheets that summarise employment data for a small fictitious company. The spreadsheets must have one row per employee. I want to populate the rows as if the spreadsheet has already been sorted, for example by grouping employees by age, and then randomise the rows so students are given spreadsheets where there is no row by row pattern to the data, for example as if employees had been entered in alphabetical order. [more inside]
posted by dowcrag on Apr 1, 2016 - 2 answers

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