Join 3,494 readers in helping fund MetaFilter (Hide)

48 posts tagged with data and excel. (View popular tags)
Displaying 1 through 48 of 48. Subscribe:

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? [more inside]
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. [more inside]
posted by Rad_Boy on Apr 14, 2014 - 6 answers

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. [more inside]
posted by TravellingCari on Jan 10, 2014 - 5 answers

I want to Excel

I need some Excel assistance. [more inside]
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? [more inside]
posted by sdis on Jul 7, 2013 - 6 answers

Data overload

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. [more inside]
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? [more inside]
posted by mxc on May 15, 2013 - 8 answers

Adventures in giant-CSV land

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. [more inside]
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. [more inside]
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. [more inside]
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? [more inside]
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. [more inside]
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? [more inside]
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. [more inside]
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!) [more inside]
posted by smirkette on Mar 26, 2012 - 10 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

Excel 2007 text to column help

Excel 2007 text to column help. [more inside]
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. [more inside]
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? [more inside]
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. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

Please help a data analysis amateur!

How to sort to count yes/no answers.... In Access or Excel. Help! [more inside]
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? [more inside]
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? [more inside]
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? [more inside]
posted by ttyn on Jul 29, 2009 - 4 answers

Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]
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. [more inside]
posted by samuelad on Mar 7, 2009 - 6 answers

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? [more inside]
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? [more inside]
posted by McBearclaw on Jan 6, 2009 - 8 answers

Need advice about statistics...

Am I distorting my data, and not showing the true picture? [more inside]
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? [more inside]
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. [more inside]
posted by simplesharps on Sep 3, 2008 - 0 answers

Timescale display in Excel

Excel/Graphing - Time vs. usage (y/n) graph [more inside]
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 [more inside]
posted by tseo on May 29, 2008 - 9 answers

Switching axis in Excel 2003

I'm using Microsoft Excel 2003 at work and I need to make a chart where the category (x) axis is the y axis; is there any way of doing this? [more inside]
posted by Rustbeard on Apr 30, 2008 - 5 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

MS Excel terror

MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]
posted by ollsen on Jan 24, 2008 - 4 answers

Cleaning up imported data in excel using VBA.

Cleaning up imported data in excel using VBA. [more inside]
posted by corpse on Dec 21, 2007 - 1 answer

excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

Manipulation of Data

Your told you have a test in Excel regarding Data Manipulation, what do you revise? [more inside]
posted by informity on Feb 13, 2007 - 11 answers

How do I remove duplicates and then merge two excel files?

In MS Excel, how do I remove duplicates, clean up a document and merge two files together? [more inside]
posted by perpetualstroll on Feb 7, 2007 - 6 answers

Strip HTML from Excel

I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]
posted by anonaccount on Oct 27, 2006 - 9 answers

Visual data organization.

I would like to make a chart like this to track my daily computer usage. Any ideas on how I could do this? Any free software you can recommend? Any way of doing it with Excel? [more inside]
posted by bubukaba on Jun 1, 2006 - 6 answers

How to share work on Excel files with formula links, sent via email?

Excel experts? Between two Excel files, anyone know how I can reassign the data source file when I'm working on my Mac with files emailed to me by my boss, created on his PC? [more inside]
posted by seaward on Nov 9, 2005 - 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

Filtering for text uniqueness in Excel

I dumped a week's worth (about 1400 rows) of successful connection data from my company's VPN concentrator logs into a .csv file containing the following columns (A through D): Date, Time, Username, Source IP. I am trying to filter the list in Excel so it only shows the most recent connection data per username, but I can't figure out how to accomplish this programmatically. [more inside]
posted by pmbuko on Apr 27, 2005 - 17 answers

Page: 1