## Data Munge: Uknown combination of 7 numbers produces a given number.

Data Munging Pros: In a spreadsheet with ten data columns, Column "A" is related to columns "B" through "J" in that some unknown combination or interaction of some or all of them will produce the data in Column "A". How do we determine what that combination is? (I can't even find what this type of problem is called, and I've not been able to find any productive Google search terms.) A more thorough explanation/example is provided in-thread.
posted by jjjjjjjijjjjjjj on Jan 17, 2017 - 13 answers

## Reorganizing Excel data

I have two related but slightly different questions about how to rearrange Excel data so that I can analyze it properly. I've been struggling with these problems for a while, and finally just gave in and am throwing myself on the mercy of MeFites.
posted by Superplin on Jan 6, 2017 - 28 answers

## How to present and evaluate data relative to weight

I could use some help walking through this: I have Excel data that means more or less depending on where it comes from. When I'm working with it, presenting it, or thinking about it, I want to treat it differently depending on origin. Example within.
posted by A Terrible Llama on Jul 19, 2016 - 11 answers

## Summarizing daily reports in Excel

I get a daily report of activity from a set of items and I want to make a automatically-updating summary sheet (I'm fine doing this in Excel, Google Sheets, or Apple Numbers).
posted by primethyme on Apr 30, 2016 - 4 answers

## Excel Question

Is it possible in excel to create a formula that says "if a value in this column is in this range of numbers, put label x in a different column."
posted by Lutoslawski on Apr 28, 2016 - 4 answers

## 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.
posted by dowcrag on Apr 1, 2016 - 2 answers

## Good Excel/CSV data visualisation tools for Windows desktops?

How can I make Excel datasets look nice without too much mucking about?
posted by turbid dahlia on Feb 15, 2016 - 6 answers

## Excel 2013 - I have no explanation for this chart behavior. Do you?

Excel 2013 - I have no explanation for this chart behavior. Do you?

## How do I supercharge Excel's Data Validation tool?

(Background at the top; question at the bottom) I work for a tech company and clients routinely send us their data for us to process. These are quasi-employee records, including the employee's department, location, age, etc. They give us all of the valid selections for each of these fields as part of their initial account setup and we can change them at any time. These are the selections they've chosen and most often match what is in their HRIS. But, they often send us mismatching data...
posted by Twicketface on Jun 3, 2015 - 3 answers

## Excel 2013 - Using data from two columns to identify a row in a third

I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result.
posted by Len on Mar 5, 2015 - 13 answers

## Cleaning up timestamp information in Metafilter Infodump

Probably pretty simple, but I would like to clean up the Metafilter Infodump timestamp, help?
posted by Sreiny on Feb 26, 2015 - 5 answers

## Master Data Me

How can I better track specific parts of my life with an app or spreadsheet?
posted by Bunglegirl on Jan 25, 2015 - 8 answers

## Excel Question: VLOOKUP and beyond?

How can I combine these two tabs of data in Excel using VLOOKUP and/or some other function?
posted by ThePinkSuperhero on Jan 15, 2015 - 9 answers

I need help with gmail functionality. I need to figure out how many(ish) extra hours I generally work. I think an easy way to capture part of this is to check out the volume of email sent outside of my working hours. Is there a reasonably easy way to do this?
posted by stormygrey on Dec 1, 2014 - 5 answers

## File woes

I grabbed a bunch of posts off of a vBulletin forum to analyze for a research project (with permission, of course, from the forums and the users and my IRB), and I've got it all cleaned up and ready to go. I've got thousands of files in .xls (Microsoft Excel 97-2003) format. So far, so good. Now how do I get these files into a format that my analysis software will play with nicely?
posted by sockermom on Jul 18, 2014 - 14 answers

## How to transfer Excel data to Powerpoint easily?

I have a list of names on an Excel file. I'd like to transfer each name (along with other details) to one PowerPoint slide. Is there any way I can do this without having to manually type in each name?
posted by AngryTypingGuy on Apr 18, 2014 - 12 answers

## How can I add straight "limit" lines to simple Excel X/Y graphs?

I'm using Excel 2010 and I'm making several x/y scatter graphs to plot QA results. I want to show on the graphs an upper and lower allowed limit for the data.

## ISO: 21st Century - information wants out of 3 ring binders

We have a number of (internal) groups providing information about (external) clients. Help me figure out the best way to track this information for easy report generation.
posted by TravellingCari on Jan 10, 2014 - 5 answers

## I want to Excel

I need some Excel assistance.
posted by pullayup on Dec 16, 2013 - 8 answers

## How can I get Excel to create multiple averages from a single table?

I have a table of data that I need to average, but I need to come up with averages using multiple different rows. For example average A=row 1, row 2, row 4: Average B= row 1, row 2, row 3: Average C= row 2, row 3. I would like to add a column that has the names of each average I need, (A, B, C) and then let excel average them based on which set they belong to. I have been looking around at other excel related forums, but I am not sure what this process is called, so I don't know how to find it. Right now I have been copying rows for each time they show up in a set I need averaged. It would be nicer to have column that says, this row belongs to set A and C, next one belongs to set A, B, and C.
posted by djpuddings on Oct 24, 2013 - 11 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?
posted by sdis on Jul 7, 2013 - 6 answers

I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore.
posted by nosila on May 30, 2013 - 6 answers

## Simple data analysis in Excel

How can I easily analyse test score data in a spreadsheet with multiple independent and dependent variables in each row?
posted by mxc on May 15, 2013 - 8 answers

Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet on May 9, 2013 - 20 answers

## MS Word / Excel 2011 for Mac catalog merge mystery

I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records. On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document.
posted by mwhybark on Apr 15, 2013 - 1 answer

## simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel.
posted by clockzero on Mar 26, 2013 - 8 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.
posted by mammary16 on Jan 18, 2013 - 8 answers

## How can I separate this data column properly?

Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,​ask:3,​meta:2,​projects:5,​jobs:5,​music:6,​irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this?
posted by iamkimiam on Sep 21, 2012 - 7 answers

## Help me pivot the pivot table back!

How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed.
posted by Frowner on Jun 20, 2012 - 6 answers

## Help me be the best data guy I can be

Part of my current job involves manipulating a large amount of data. I need to learn how to do this more efficiently and on a larger scale. What should I use? What should I learn? What is the best (free) way to teach myself?
posted by dersins on Jun 18, 2012 - 26 answers

## And maybe something with dollar signs I don't know

Need help with (possibly?) "indirect" in Excel.
posted by phunniemee on May 16, 2012 - 21 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!)
posted by smirkette on Mar 26, 2012 - 10 answers

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

## Excel 2007 text to column help

Excel 2007 text to column help.
posted by Ezrie on Nov 30, 2010 - 19 answers

## Data table sources with multiple pagination

i need to gather data from paginated tables and return them as a feed or something that can be easily pulled as a query into excel.
posted by malcommc on Oct 21, 2010 - 4 answers

## How does one auto-fill an Excel spreadsheet with terms?

How does one auto-fill an Excel spreadsheet with terms from another data source?
posted by Fiasco da Gama on Jul 20, 2010 - 9 answers

## Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature.
posted by angelaas525 on Jul 9, 2010 - 4 answers

How to sort to count yes/no answers.... In Access or Excel. Help!
posted by BusyBusyBusy on Jul 6, 2010 - 16 answers

## Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate?
posted by rollick on Nov 4, 2009 - 9 answers

## How to merge data from two excel sheets into one?

How to merge data from two excel sheets into one?
posted by willy_dilly on Oct 9, 2009 - 6 answers

## Lusting for Tableau

What are some affordable alternatives to Tableau for data visualization, plotting, etc?
posted by ttyn on Jul 29, 2009 - 4 answers

## Excel, Pivot, Dates.

Excel - Pivoting With Dates
posted by SirStan on Mar 25, 2009 - 3 answers

## How can I best visualize performance data by tenure?

Excel charting help: Help me analyze sales stats based on salesperson tenure.

## Software for making clever information visualizations?

How to make clever visualizations from Excel or CSV data? Any free, flexible information-graphic scripting software out there?
posted by anthill on Feb 23, 2009 - 10 answers

## Automating monkeywork in Excel and Word

Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template?
posted by McBearclaw on Jan 6, 2009 - 8 answers

Am I distorting my data, and not showing the true picture?
posted by matholio on Nov 18, 2008 - 9 answers

## Can I make an Excel chart from only one column?

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column?
posted by niles on Oct 20, 2008 - 7 answers

## Escaping the grind

My friend works in database applications each day to create in house reports. He's bored and wants to go it alone.
posted by simplesharps on Sep 3, 2008 - 0 answers

## Timescale display in Excel

Excel/Graphing - Time vs. usage (y/n) graph
posted by SirStan on Aug 25, 2008 - 6 answers

## Data visualisationfor presentations

I am looking for some good data visualisation books, tutorials and maybe software
posted by tseo on May 29, 2008 - 9 answers

Page: 1 2