5 posts tagged with spreadsheets and data.
Displaying 1 through 5 of 5. 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

Correlating names between two spreadsheets

I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names. [more inside]
posted by mammary16 on Jan 18, 2013 - 8 answers

Why don't they teach us how to prep the numbers as well as how to crunch them?

ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
posted by smirkette on Mar 26, 2012 - 10 answers

How do I important the data from hundreds of documents into spreadsheets?

How do I use OCR to scan a standard document into an excel spreadsheet? [more inside]
posted by perpetualstroll on May 3, 2011 - 3 answers

Cell 64,999

I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste? [more inside]
posted by Happydaz on Jul 4, 2005 - 6 answers

Page: 1