871 posts tagged with excel.
Displaying 751 through 800 of 871. Subscribe:

File listing help

How can I easily get all the music files on my computer listed on to an excel spreadsheet? [more inside]
posted by Todd Lokken on Jul 21, 2006 - 9 answers

Excel Hours Mins

Excel Filter: I need to convert a wallop load of cells that are in decimal format to hours & minutes format. Please. More Inside. [more inside]
posted by kev23f on Jul 21, 2006 - 15 answers

Pre-1900 dates in Excel?

Is there any way to make Microsoft Excel recognize dates before 1900? [more inside]
posted by marxchivist on Jul 19, 2006 - 10 answers

Excel help needed

How do I work with (merge) these 2 Excel Spreadsheets? [more inside]
posted by valleys on Jul 15, 2006 - 5 answers

How to fix the number format of an Excel file

Is it possible to stipulate that a Microsoft Excel file will always display a specific number format e.g. the Anglo-American decimal point, regardless of the local settings of the computer where it is viewed? [more inside]
posted by rogerh on Jul 13, 2006 - 3 answers

How to highlight cells in excel with a keystroke.

MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.
posted by bigmusic on Jul 8, 2006 - 8 answers

Data Organization Software Anyone?

DataOrganizationFilter: I am looking for software that will allow my market research team to efficiently store and access information from PDF and Excel files. [more inside]
posted by drkrdglo on Jun 28, 2006 - 6 answers

Point plotting problems!

Excel 2003 graph woes. My friend is looking to make a simple x:Date; y:Value chart but with one problem. [more inside]
posted by jedrek on Jun 22, 2006 - 6 answers

How to change poorly formatted text into a usable database.

I have a directory which is swell for printing, but I need it in a database. [more inside]
posted by Classic Diner on Jun 22, 2006 - 3 answers

I just wanna hide!

I have an Excel worksheet populated with data from columns A through IS. I’d like to hide columns but I am getting the following error: “Cannot shift objects off sheet.” Why? [more inside]
posted by phoenixc on Jun 19, 2006 - 5 answers

Excel - Concatenate fields through Vlookup...or something

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]
posted by bwilms on Jun 9, 2006 - 10 answers

Excel: How to write a formula that calculates weekly pay?

Excel: How do you write a formula that calculates weekly pay? [more inside]
posted by dabradfo on Jun 7, 2006 - 13 answers

How to correctly export columnar labels from Word into Excel?

A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean on Jun 6, 2006 - 6 answers

Excel text hacks?

Stripping out extra text in Excel? [more inside]
posted by Gilbert on Jun 2, 2006 - 8 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

Tracking UPS Packages in Excel?

Is there a way to import UPS tracking information into an MS Excel document? [more inside]
posted by dripdripdrop on May 29, 2006 - 6 answers


I need help with an Excel formula. Warning: this may venture into the realms of calculus. Maybe. [more inside]
posted by thecjm on May 21, 2006 - 7 answers

Rolling Averages in Excel?

Excelfilter: how do I compute a rolling seven-day average for something that happens at sporadic intervals? [more inside]
posted by jessamyn on May 21, 2006 - 21 answers

Excel Help for Pie Graph of Frequency of Appearance of Values in a Column?

ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.) [more inside]
posted by WCityMike on May 19, 2006 - 9 answers

What's the best way to make an ellipse (rather than bubble) chart in Excel?

Let's say I want to make a chart that's like an excel bubble chart, but I don't want the size of the bubble to vary depending on a third variable. Instead, I want the width of each bubble to vary by some amount, and the height of each bubble to vary by a different amount. [more inside]
posted by sentient on May 15, 2006 - 2 answers

Excel- conditional data copy

Excel use question: what's the term (and usage, if you don't mind) for the concept of "copy only the rows with (special indicator here) from that worksheet"? [more inside]
posted by Steve3 on May 15, 2006 - 3 answers

Working with Excel 95 files

How can I convert Excel 95 to at least '97 when uploaded to a server (iis) or... [more inside]
posted by Mick on May 2, 2006 - 7 answers

A really simple Excel question, except for someone like me

MS Excel question. [more inside]
posted by Mr. Justice on Apr 28, 2006 - 6 answers

I hate Visual Basic

MSExcel: how to place data in one cell from an ODBC source based on data in another cell? [more inside]
posted by randomstriker on Apr 26, 2006 - 1 answer

Help me set Firefox as the default browser. No, really.

I installed MS Excel after Firefox and now Excel is convinced that URLs need to open in Internet Explorer. I tried the suggestions in Excel's help file to change it back. They didn't work. [more inside]
posted by Tuwa on Apr 24, 2006 - 9 answers

Missing Formula Bar

Excel for OSX Filter: My Formula bar disappeared and I can't get it back! [more inside]
posted by crapples on Apr 23, 2006 - 3 answers

Can I get a hybrid text file/spread sheet?

I'd like a word processor that mimics Excel sheets. [more inside]
posted by oddman on Apr 14, 2006 - 10 answers

Best Fit Ellipse?

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 - 33 answers

How to run a SQL Query on an Excel Spreadsheet

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 - 6 answers

“Eventually, all things merge into one, and a river runs through it.”

Complex Excel to Word merge question is the [more inside]
posted by anastasiav on Apr 6, 2006 - 10 answers

Help me calculate a hidden value in my data

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 - 14 answers

Excel formula for calculating age

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 - 12 answers

Very likely the dumbest Excel question ever asked

MS Excel: How do I convert a number representing seconds into minutes:seconds? [more inside]
posted by contessa on Apr 3, 2006 - 13 answers

Pivot Table Charting Help

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]
posted by dantodd on Mar 30, 2006 - 4 answers

Exporting outlook email headers

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 - 6 answers

Digital Signature?!

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. [more inside]
posted by JonnyRotten on Mar 22, 2006 - 12 answers

I Wish I Was an Excel Programmer

I appeal to the Excel gods of AskMe for help. My problem is similar to the one answered here, but is more complicated... [more inside]
posted by Irontom on Mar 9, 2006 - 10 answers

How do I find a reliable person to do some computer work for me?

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 - 14 answers

Killing a Phantom Menu in Excel

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 - 6 answers

Add "http://" Prefix to a List of Domains Formatted in Plain Text :: How Please?

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: ""). There are just to many to go through and add this to each one. [more inside]
posted by Jhaus on Feb 21, 2006 - 8 answers

How to generate in Excel a pay stub with a "Year to Date" column?

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. [more inside]
posted by ShooBoo on Feb 17, 2006 - 6 answers

Carriage Returns in Excel

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 - 9 answers

Is there a regexp for Excel?

ExcelFilter: How do I convert a column of names formatted Smith, John into John Smith. Feasible?
posted by furtive on Feb 9, 2006 - 8 answers

MS Excel Sorting

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 - 18 answers

Filter by month, not year in Excel?

How do I sort a column of birthdates in Excel to by month and NOT year? [more inside]
posted by ggypsy on Feb 4, 2006 - 9 answers

Excel-fu needed.

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 - 10 answers

MS Excel database question

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 - 8 answers

Working with Text in Columns in Excel -- please help

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 - 7 answers

Dial phone numbers from Excel?

Want to dial my softphone from Excel. [more inside]
posted by TeamBilly on Jan 16, 2006 - 4 answers


PivotTableFilter: Can I have columns by month if I have the full date? [more inside]
posted by pithy comment on Jan 13, 2006 - 17 answers

Page: 1 ... 11 12 13 14 15 16 17 18