How can one create a best fit ellipse around a cluster of (x,y) points in a scatter plot within Excel? [more inside]
posted by geonags
on Apr 12, 2006 -
I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark
on Apr 7, 2006 -
I've spent the past day or so trying to figure out how to calculate a hidden value in my data. It varies linearly with time, or closely enough that we can make that assumption within any given dataset. Where this goes beyond a simple linear regression is that each datapoint is known to be above or below the hidden value. The data is collected in a C# program and processed in Excel; an Excel function would be the ideal solution. [more inside]
posted by bjrubble
on Apr 3, 2006 -
Our lab uses Excel to record vital data about the participants in our studies. We usually record a date of birth and the date a child was run in separate cells. However we've had no luck creating a formulatthat calculates the person's age (in months, or in years;months) based on those two other cells. As a result of having to do it by hand, errors often occur. Ideally, I'd like to customize how rounding happens, but at this point I'll take what I can get.
posted by drmarcj
on Apr 3, 2006 -
Help me with creating two bar charts from two columns in one pivot table, please? [more inside]
posted by dantodd
on Mar 30, 2006 -
So I'm doing my expenses, and I want to see every night I sent an email after 8:00 or so, because that implies I took a cab home that night. (I can bill them without receipts, but I want to be honest and I'm doing this for a couple months.) Is there a way to export email headers from Outlook to excel or a csv file, so I can sort them by time and count up my trips?
posted by mtstover
on Mar 27, 2006 -
Digital "Signature" in an excel spreadsheet, is it easy and possible?
My company wants to reduce our paper waste and do digital copies of some of our internal forms. But we need an easy way to digitally sign the documents throughout the various stages of approval.
posted by JonnyRotten
on Mar 22, 2006 -
I appeal to the Excel gods of AskMe for help. My problem is similar to the one answered here
, but is more complicated...
posted by Irontom
on Mar 9, 2006 -
I need some computer work done for me and I'm not sure how to find someone to do it. [more inside]
posted by ikkyu2
on Mar 6, 2006 -
Elite Tech Support Needed. Where does what's left of this plugin live? This one is elusive.... [more inside]
posted by tiamat
on Feb 22, 2006 -
Hi, hoping some MS Excel or HTML wizards can help me out with this. The goal is as follows; format a list of domain names so I can publish them on a webpage with hyperlinks to their individual addresses (currently they are all in Excel with each domain occupying a single cell in a single row; they are currently formatted like this: "domain.com")
. There are just to many to go through and add this to each one. [more inside]
posted by Jhaus
on Feb 21, 2006 -
I'm using Excel to create a weekly pay stub for a nanny, but I haven't figured out how to automatically include the previous week's data to create a "Year to Date" column for wages and taxes.
posted by ShooBoo
on Feb 17, 2006 -
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
posted by godawful
on Feb 10, 2006 -
ExcelFilter: How do I convert a column of names formatted Smith, John
into John Smith
posted by furtive
on Feb 9, 2006 -
I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
posted by panoptican
on Feb 8, 2006 -
Excel problem. How do I convert the following number format.
106026 where from left - first digit is CENTURY. Next two are YEAR and last three are JULIAN DAY. So last example is CENTURY 1, YEAR 06, and 26th Julian day of the year.
I would like to convert to to mm/dd/yy. Anyone have good Excel-fu for this?
posted by thimk
on Jan 26, 2006 -
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
posted by Mr. Justice
on Jan 22, 2006 -
Excel Question: I have 2 lists of text data separated into 2 columns -- column A and column B. Column A is a significantly longer list (close to 10k cells) than Column B (5-6k cells), but many of the cells in Column A are identical to cells in Column B. What I would like to do is generate a Column C that only contains cells from Column A that are NOT also in Column B. [more inside]
posted by Soulbee
on Jan 19, 2006 -
Excel's built-in conversion to HTML results in a monstrosity of a web page. Can anyone recommend the best "scrubber" or converter utility that does the best job (Windows or Mac)?
posted by spock
on Jan 12, 2006 -
Excel Wizards (or Apprentices, Probably) Grading is upon me again and there's something I've always wanted to do in Excel automatically -- from a range of values, drop the lowest N values and average the rest. [more inside]
posted by ontic
on Dec 19, 2005 -
Microsoft Excel. Is it possible to insert some "alarm" function that will notify me if I insert duplicate text in later cells? [more inside]
posted by Amizu
on Dec 7, 2005 -
I hate Excel. I have a load of data in an HTML table. One of the columns has the data in the format xx:xx.x (e.g. 03:45.7). THIS IS NOT A TIME. IT JUST LOOKS
LIKE ONE. Whenever and however I import this into Excel, it will always import it as a time causing me no end of aggrevation. [more inside]
posted by Hartster
on Dec 5, 2005 -
In Excel 2002 when I create a PivotChart and apply a custom or user-defined chart type (in this instance a 2-axis line chart), the chart type reverts to a standard single-axis line chart whenever I modify one of the PivotFields. How do I prevent this? [more inside]
posted by Ritchie
on Nov 30, 2005 -
Using MS Excel 2002 (Win), my mom has managed to reverse the order of the columns at the top of the page (Z to A instead of the usual). _Not_ the actual cell entries, but the columns themselves appear in reverse order. She has no idea how/when she did it.
posted by rexruff
on Nov 11, 2005 -
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 -
Is there an excel version of writely.com? In other words, I need to find a free, collaborative, spreadsheet app hosted online. Does it (or something close to it) exist?
posted by limitedpie
on Oct 17, 2005 -
I'm looking for advice on teaching basic Excel skills to adults in a classroom setting. [more inside]
posted by jessamyn
on Oct 10, 2005 -
ExcelFilter: I know how to import a text file into Excel using the wizard for fixed column widths. Can I automate the process? [more inside]
posted by Lokheed
on Oct 5, 2005 -
Is there a quick way to create a mail merge directory in Word from an Excel spreadsheet, broken down by a specific field (department, category, etc.)? This seems like a Microsoft 101 question, but the built-in Help doesn't seem to address this specifically, and online help
from Word 2002 gets into code I can't even begin to understand. [more inside]
posted by pzarquon
on Sep 7, 2005 -
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted by clgregor
on Sep 2, 2005 -
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted by michaelkuznet
on Sep 1, 2005 -
Excel - I am interviewing a couple of people tomorrow for an admin job within my team. One of the things we want to check is their proficiency with Excel. Does anyone know of a site that has a downloadable Excel spreadsheet that we could give them as a test
posted by lloyder
on Aug 24, 2005 -
Is there a way to prevent a Pivot Table (in Excel) from displaying a row with all zeros? [more inside]
posted by grateful
on Aug 10, 2005 -
Timecode filter: how do I subtract a given number of frames from 400 timecodes in an Excel spreadsheet? [more inside]
posted by forallmankind
on Jul 5, 2005 -
Help me get a professional massage!
What is a "named range" in Excel and how do I create one? I cannot import an .xls file into her outlook contact folder until I address this issue. [more inside]
posted by sourwookie
on Jul 5, 2005 -