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

847 posts tagged with excel. (View popular tags)
Displaying 201 through 250 of 847. Subscribe:

Related tags:
+ (193)
+ (88)
+ (68)
+ (51)
+ (48)
+ (45)
+ (45)
+ (35)
+ (30)
+ (30)
+ (25)
+ (24)
+ (22)
+ (22)
+ (21)
+ (20)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
Anonymous (4)
willnot (4)
FireStyle (4)
desjardins (4)
zardoz (4)
SirStan (3)
Jackie_Treehorn (3)
jujube (3)
goethean (3)
skypieces (3)
jefficator (3)
bluejayway (3)
mwhybark (3)
anastasiav (3)
Conrad Cornelius o... (3)
undercoverhuwaaah (3)
stupidsexyFlanders (3)
sdis (3)
foxinthesnow (3)
Mr. Justice (3)
ttyn (3)
corpse (3)
GilloD (3)
keep it tight (3)
apark (3)
Carialle (2)
bluefly (2)
demagogue (2)
bibbit (2)
Irontom (2)
Seeba (2)
Rad_Boy (2)
skryche (2)
thankyoumuchly (2)
synecdoche (2)
Lentrohamsanin (2)
digiFramph (2)
Jimbob (2)
rippersid (2)
furtive (2)
monocultured (2)
jestonb (2)
lea724 (2)
beammeup4 (2)
xedrik (2)
sockpim (2)
pwb503 (2)
nickerbocker (2)
ObscureReferenceMan (2)
crapmatic (2)
pantufla (2)
rorycberger (2)
prunes (2)
ParisParamus (2)
WCityMike (2)
dmd (2)
ewiar (2)
squorch (2)

Excel Tables

Link to a table in Excel 2011? [more inside]
posted by alextprice on Jul 11, 2011 - 1 answer

Please help me with an Excel formula.

How can I use Excel to automatically calculate the average of the best two of three results? [more inside]
posted by MighstAllCruckingFighty on Jul 4, 2011 - 10 answers

Excel help needed!

I have a formula for inputting into my expense sheet but it doesn't populate the field like it should. I stole the formula from my time sheet, and that does populat the column for the 4 weeks after I manually put in date 1. It is: =IF($B$4=0,"",SUM(B4+1)) So...why does it work in one sheet but not the next? [more inside]
posted by dash_slot- on Jul 1, 2011 - 7 answers

Saving .csv files in Excel

About a dozen people have tried to solve this. All failed. Exporting from Excel to .csv causes cells to show #NAME? instead of the actual value. [more inside]
posted by Mr_Zero on Jun 30, 2011 - 7 answers

Can I get anything useful out of my savings history?

As a result of my method for saving money, I've ended up with a huge excel spreadsheet for the last 4 years detailing how much I've put in and taken out of my savings account. The problem is that although I've taken time to record all this information, I've now realised that I'm not sure what I can actually do with it. Do you have any ideas? [more inside]
posted by mr_silver on Jun 30, 2011 - 12 answers

Calculating durations and times in Excel

Excel help needed in calculating times. I need to calculate and predict times based on fixed distances and a known average speed. [more inside]
posted by dg on Jun 28, 2011 - 8 answers

Outlook screws up pasted Excel objects

Why does Outlook render spreadsheet data pasted into an email so shittily, and how can I avoid this? [more inside]
posted by goethean on Jun 28, 2011 - 11 answers

I don't think Fortran and punchcards cut it anymore...

Which programming languages are best suited to creating a timetabling application? [more inside]
posted by bister on Jun 26, 2011 - 16 answers

Excel Formula for First Instance of Something in Row, Then Top Value in That Column?

Excel question (debt management/budgeting): what formula gets me the first instance of something in a row, and then how I can pull the date from the top of that column? More inside. [more inside]
posted by WCityMike on Jun 23, 2011 - 8 answers

Does excel have a WHERE clause?

I have an excel file with a list of expenses that are continually updated, sorted by date. There is a column for specifying the category that each expense belongs to. Is it possible to create a formula that adds up the expenses that belong to a specific category? [more inside]
posted by Phire on Jun 21, 2011 - 4 answers

Building the simplest payroll template in Excel. No, really simple.

I'm dusting off my rusty Excel skills to try to build an easy-to-use, easily updated very basic payroll spreadsheet for a userbase which is completely unfamiliar with Excel. [more inside]
posted by nevercalm on Jun 2, 2011 - 9 answers

I got 99 problems and Excel isn't one of them.

How do I, using Excel, determine the frequency of orders, the minimum/maximum amount per customer and the average order size? [more inside]
posted by hecho de la basura on May 21, 2011 - 11 answers

The extract range has a missing or illegal field name.

Does anyone have a handly list of reasons why one would get the error "The extract range has a missing or illegal field name." when using advanced auto-filter? [more inside]
posted by Lucubrator on May 17, 2011 - 0 answers

How can I more easily edit CSV tables in Access or Excel?

I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside. [more inside]
posted by filthy light thief on May 16, 2011 - 7 answers

Show all formulas.

I'm an artist. Please help me find a day job that makes use of my bizarre love of spreadsheets. [more inside]
posted by HeroZero on May 15, 2011 - 8 answers

Need help with (presumably) conditional formatting issue in excel

How do I use two cells to conditionally target a different cell? [more inside]
posted by FireStyle on May 11, 2011 - 3 answers

Using Table data to automatically (re)name worksheets in Excel 2007?

In Excel 2007 can I use data in a column on one spreadsheet to automatically change the name of another spreadsheet in the same workbook? [more inside]
posted by Lentrohamsanin on May 10, 2011 - 2 answers

Excel Wizardry Needed

Excel question: How can I tally by quarter when all I have are dates? Bonus challenge details inside. [more inside]
posted by unannihilated on May 9, 2011 - 5 answers

Copying contents of cells in Excel

How do I create a macro in Excel that copies the contents of the cell two cells to the target's right and appends the contents to the end of the target cell? Both cells contain alphanumeric strings. [more inside]
posted by geoffr on May 3, 2011 - 7 answers

How Can I Make This Chart in Excel 2010?

Can you help me change the color on part of a chart in Excel 2010? [more inside]
posted by Bugbread on Apr 24, 2011 - 4 answers

There's data just waiting to be scraped....

Excel-macro filter / this-must-be-possible filter: copy and paste a cell (say, A2) into Google Maps, hit submit, then copy and paste the first phone number into an empty cell (say, A10). How to make it work? [more inside]
posted by chrisinseoul on Apr 18, 2011 - 9 answers

Please default to column headers, Excel.

How do I get Excel 2007 default to using column headers when I'm sorting? [more inside]
posted by Dolley on Apr 12, 2011 - 8 answers

Help my theoretical trains not crash.

I have a rather specific excel question. Please help me. [more inside]
posted by millipede on Apr 6, 2011 - 9 answers

Please help me with this encoding issue!

Please help me with this encoding issue! Fun with Python, Unicode, Excel, and the IPA. [more inside]
posted by ootandaboot on Apr 2, 2011 - 13 answers

Excel 2010: How to Highlight Row and Column of Selected Cell

Excel 2010- I need to highlight both the row and the column of the cell that is currently selected in my enormous spreadsheet. Can you help me accomplish this?
posted by Irontom on Mar 28, 2011 - 5 answers

EXCEL Vs. Time Left

Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date. [more inside]
posted by TeachTheDead on Mar 25, 2011 - 9 answers

I Know What I Know.. But How Do I Know What I Don't Know?

Excel Filter: I have a long list of file names in numerical order in an Excel spreadsheet. I need to know what numbers are missing, so I can track down the related files. Is there a quick and (relatively) painless way of doing this without having to sift through all the numbers manually?
posted by Philby on Mar 24, 2011 - 5 answers

The Power of Excel Compels You!

Help me pass a test using Excel (special snowflake banking industry questions inside). [more inside]
posted by digitalprimate on Mar 24, 2011 - 8 answers

How to line up data based on a single identifier?

MS Excel: All of my subjects took two tests and Scores 1 & 2 are in one sheet. Some of my subjects took an additional two tests, and Scores 3 & 4 are in another sheet. How can I merge the two sheets and align the rows so that each subject has all four scores in individual cells in a single row? [more inside]
posted by oceanmorning on Mar 24, 2011 - 6 answers

Good help forum for Office 2010?

Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is the one. Thanks!
posted by The Dutchman on Mar 19, 2011 - 7 answers

stymied by excel

There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data. asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle on Mar 17, 2011 - 6 answers

How can I link to specific places in a variety of documents?

How can I create a web-based table of contents that links to specific places within a diverse collection of documents? [more inside]
posted by kirkaracha on Mar 17, 2011 - 4 answers

EXCELerate My Workflow

Excel 2011: How do I create custom styles for Conditional Formatting? [more inside]
posted by 47triple2 on Mar 15, 2011 - 2 answers

colour me worried

Help! My painstaking hours in Excel won't transfer to Powerpoint! [more inside]
posted by whalebreath on Mar 14, 2011 - 7 answers

My googles are failing me

Is there a quick and easy SAAS program I can use that replicates the functionality of MS Excel pivottables but on the web? [more inside]
posted by jourman2 on Mar 14, 2011 - 6 answers

I don't want to Excel, just get by...

My conditional formatting in Excel 2007 is at war with itself. Help me emerge the victor. [more inside]
posted by jph on Mar 8, 2011 - 11 answers

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows?

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
posted by bottlebrushtree on Mar 5, 2011 - 7 answers

How export list of sent emails?

Outlook filter: How can I export a list of sent emails to Excel? [more inside]
posted by LonnieK on Feb 17, 2011 - 3 answers

I love Excel... when I know what I'm doing

ExcelFilter: I have Worksheet1 and Worksheet2. Both worksheets contain PersonName on the X-axis, ClassName on the Y-axis. I need to run some comparison between the two. Thinking of doing this on a 3rd worksheet. Here's where it gets tricky: 1. There are several thousand PersonNames. 2. There are about 100 CourseNames. 3. There is volatility in the PersonNames and CourseNames; they will be constantly changing, especially, the PersonNames. [more inside]
posted by demagogue on Feb 15, 2011 - 5 answers

Excel 2003 Page Break/Print Area Q

Microsoft Excel 2003 Question: Can I manually set the Page Breaks in Page Break Preview, and THEN print the document so that each manually set page will fill the entire printed sheet of paper? [more inside]
posted by ThePinkSuperhero on Feb 1, 2011 - 3 answers

How can I reuse a Query Builder query?

Is there any way to save a query in MS Office 2011's Query Builder that isn't tied to a specific spreadsheet? [more inside]
posted by mph on Feb 1, 2011 - 0 answers

How to port Excel applications to the Web?

What would be the best technology to port simple Excel-based applications to the web? [more inside]
posted by elgilito on Jan 29, 2011 - 11 answers

Spreadsheet Data Sorting

Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet? [more inside]
posted by DrtyBlvd on Jan 28, 2011 - 7 answers

How to keep lists sorted both horizontally and vertically?

Sorting and keeping track of my research: is Excel the best solution? [more inside]
posted by pipti on Jan 27, 2011 - 13 answers

Please help me out of a Microsoft Excel morass

If I don't figure out a solution, I may be doomed to hours upon hours of copying and pasting in Excel. My brain is crying out in pain for a solution, but I've never encountered this issue before. I need to transform sheet names into a variable on the sheet they represent. I'll try to explain this better inside. [more inside]
posted by SpicyMustard on Jan 27, 2011 - 14 answers

Fancy concatenate in Excel?

How do I combine two columns of text in Excel but maintain the formatting (italics and superscript) of the original cells? [more inside]
posted by _cave on Jan 24, 2011 - 3 answers

Excel multi-word list items possible?

Excel question: Is there any way to have multi-word options (without underscores) in a drop-down list that will be used as a condition for a second drop-down list? [more inside]
posted by Awkward Philip on Jan 21, 2011 - 2 answers

How to copy and paste quickly in Excel 2011 for Mac.

In Excel 2011 for Mac, everything slows to a crawl if I cut or copy a large number of cells. Is there any way to fix this? If not, is there a different spreadsheet program that could do this quickly? [more inside]
posted by eisenkr on Jan 20, 2011 - 14 answers

Making a dumb spreadsheet smart

I'm having trouble solving a problem in Google Spreadsheet. [more inside]
posted by downing street memo on Jan 14, 2011 - 3 answers

Edit a master spreadsheet remotely with a Droid over Bluetooth?

What's the best way to edit a spreadsheet on my PC from across the room, using a Droid over Bluetooth (not WiFi)? [more inside]
posted by Alabaster on Jan 13, 2011 - 3 answers

Page: 1 2 3 4 5 6 7 8 ... 17