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

Can a sortable spreadsheet exist in a PDF?

I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]
posted by Servo5678 on Feb 17, 2012 - 5 answers

Does excel have a WHERE clause?

I have an excel file with a list of expenses that are continually updated, sorted by date. There is a column for specifying the category that each expense belongs to. Is it possible to create a formula that adds up the expenses that belong to a specific category? [more inside]
posted by Phire on Jun 21, 2011 - 4 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

Puzzles Weren't My Major: How Do I Re-Order An Mixed Up List?

Help me sort out this problem of ranking bracket winners... Thx in advance, hivemind. [more inside]
posted by mhh5 on Jan 22, 2009 - 7 answers

Case-sensitive, but not sensitive enough

Can Excel 2003 sort (or filter) primarily on case? [more inside]
posted by Chrysostom on Jul 30, 2008 - 8 answers

Show me how Excel can sort numbers and text in the order I want

Any Excel gurus in the room? I have an Excel spreadsheet with over 800 rows of data. Each row begins with a number (like 0001), and some have letters after the numbers (like 0001a). The Sort function doesn’t sort the way I’d like it to. [more inside]
posted by Milkman Dan on Apr 17, 2008 - 7 answers

How to alphabetize a list while ignoring articles?

Can I alphabetize data in Excel (or elsewhere) while ignoring the articles "the", "a" and "an"? [more inside]
posted by Burns Ave. on Feb 20, 2008 - 10 answers

Help me sort my rows please!

Is there a way to sort by "highlighted field" in Excel? [more inside]
posted by BuddhaBelly on Sep 11, 2007 - 5 answers

Page: 1