##
54 posts tagged with excel *and* data.

Displaying 1 through 50 of 54. Subscribe:

## 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... [more inside]

## 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. [more inside]

## Cleaning up timestamp information in Metafilter Infodump

Probably pretty simple, but I would like to clean up the Metafilter Infodump timestamp, help? [more inside]

## Master Data Me

How can I better track specific parts of my life with an app or spreadsheet? [more inside]

## Excel Question: VLOOKUP and beyond?

How can I combine these two tabs of data in Excel using VLOOKUP and/or some other function? [more inside]

## Help me quantify extra hours, please, please, a please please.

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? [more inside]

## 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]

## 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?

## 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]

## 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]

## I want to Excel

I need some Excel assistance. [more inside]

## 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.

## 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]

## 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]

## 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]

## 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?

## 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]

## simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel. [more inside]

## 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]

## 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]

## 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]

## 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]

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

Need help with (possibly?) "indirect" in Excel. [more inside]

## 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]

## Panning for email addresses

How do I sort the (potentially) real email addresses from the garbage data in Excel 2003? [more inside]

## Excel 2007 text to column help

Excel 2007 text to column help. [more inside]

## 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]

## 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]

## Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]

## Please help a data analysis amateur!

How to sort to count yes/no answers.... In Access or Excel. Help! [more inside]

## Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]

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

How to merge data from two excel sheets into one? [more inside]

## Lusting for Tableau

What are some affordable alternatives to Tableau for data visualization, plotting, etc? [more inside]

## Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]

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

Excel charting help: Help me analyze sales stats based on salesperson tenure. [more inside]

## 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]

## 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]

## Need advice about statistics...

Am I distorting my data, and not showing the true picture? [more inside]

## 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]

## 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]

## Timescale display in Excel

Excel/Graphing - Time vs. usage (y/n) graph [more inside]

## Data visualisationfor presentations

I am looking for some good data visualisation books, tutorials and maybe software [more inside]

## 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]

## 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]

## MS Excel terror

MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]

## Cleaning up imported data in excel using VBA.

Cleaning up imported data in excel using VBA. [more inside]

## 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]

## Manipulation of Data

Your told you have a test in Excel regarding Data Manipulation, what do you revise? [more inside]

## 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]

## 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]

Page:
1 2