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

852 posts tagged with excel. (View popular tags)
Displaying 101 through 150 of 852. Subscribe:

Related tags:
+ (196)
+ (90)
+ (68)
+ (51)
+ (48)
+ (45)
+ (45)
+ (35)
+ (31)
+ (30)
+ (25)
+ (25)
+ (22)
+ (22)
+ (21)
+ (21)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (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)
willnot (4)
Anonymous (4)
zardoz (4)
desjardins (4)
FireStyle (4)
stupidsexyFlanders (3)
goethean (3)
anastasiav (3)
mwhybark (3)
keep it tight (3)
sdis (3)
Mr. Justice (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
undercoverhuwaaah (3)
jujube (3)
Jackie_Treehorn (3)
skypieces (3)
ttyn (3)
bluejayway (3)
Conrad Cornelius o... (3)
thankyoumuchly (2)
Flunkie (2)
freddymetz (2)
ewiar (2)
bleucube (2)
jestonb (2)
underwater (2)
slavlin (2)
johnstein (2)
beammeup4 (2)
pdb (2)
pantufla (2)
nevercalm (2)
rossination (2)
johngoren (2)
digitalprimate (2)
Classic Diner (2)
bibbit (2)
SheIsMighty (2)
Rock Steady (2)
WCityMike (2)
nickerbocker (2)
panoptican (2)
nooneyouknow (2)
furtive (2)
ObscureReferenceMan (2)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
pwb503 (2)
Jimbob (2)
jessamyn (2)

How can I make excel break multiple rows into new sheets without doing it manually?

How can I make excel break each common row off into a new sheet? [more inside]
posted by Calicatt on Nov 13, 2012 - 10 answers

Giant CSV Files Needed

Where can I find publicly-available scientific data to use in an Excel project? [more inside]
posted by anaximander on Oct 30, 2012 - 18 answers

Excel Help

Excelfilter: How do I find and replace (e.g. replace 17 for 18) a set of numbers in the format: 17-01-06 without it being recognised as a date? [more inside]
posted by freddymetz on Oct 30, 2012 - 4 answers

In Excel, getting the MEDIAN of a set based on a text pattern match

In Excel, I have two columns. Column A has many rows of names (e.g., Mary, Maryjane, Maryanne, Anne, Jane) and in Column B I have their ages (e.g., 4, 20, 40, 10). I would like to find the MEDIAN age of all the "mary's"; i.e., both "mary" and "maryanne", etc. Is this possible? I have been getting errors on variations of {=MEDIAN(IF(A1:A4="*mary*",B1:B4))} constructions... I do not want to use VBA. thank you!
posted by noway on Oct 26, 2012 - 5 answers

Examples of non math uses for Excel

For a project, I'm trying to collect uses of Excel that do not include any formulas or other use of math. What are some common documents that people use the format of Excel to create in an office setting? [more inside]
posted by sweetkid on Oct 26, 2012 - 68 answers

Excel colour schemes are making me go blind

How do I permanently change the colour scheme in Excel (2010) so that I don't keep on going blind due to other people's spreadsheets? [more inside]
posted by Katemonkey on Oct 18, 2012 - 16 answers

What's the quickest way to code this data?

I have an Excel spreadsheet with just over 3000 sentences in column A. I need to go through looking at each one and entering some data into columns B-F. The first thing I have to enter is whether the sentence is in the past tense or present tense. If it is past tense, I can ignore it and not have to enter anything in columns C-F. I just move on to the next sentence. Is it going to be quicker if I go through the whole spreadsheet filling out column B first (past/present) and then do a second pass to fill out the rest of the details for the present tense sentences, or quicker to do it all at once for each sentence? Or is it a wash? [more inside]
posted by lollusc on Oct 16, 2012 - 8 answers

How to Highlight All Cells Containing Future Date in Excel 2007

In Excel 2007, is there a way to highlight all cells within a certain range (in my case, five adjacent columns) that contain dates in the future? [more inside]
posted by smirkyfodder on Oct 15, 2012 - 2 answers

excel income tax calc help

Excel help: I'm trying to input a dollar value into a cell and have the output be the federal income tax for that amount (just using the brackets). Federal income tax is calculated such that the first x dollars are taxed at rate R, the next y dollars are taxed at rate S, and up through several different rate brackets. I can do this calculation with a simple IF statement using multiple cells by summing the result of 5 separate bracket calculations. I'm not sure if I can cram it into one giant formula. Suggestions? [more inside]
posted by leotrotsky on Oct 13, 2012 - 4 answers

Excel Formatting(?) Question

There must be a simple solution to this Excel issue I'd like to fix. [more inside]
posted by digiFramph on Oct 12, 2012 - 8 answers

Ideal ranges in excel charts?

Displaying ideal ranges in the plot area of an Excel 2007 chart. Possible? [more inside]
posted by xyzzy on Oct 11, 2012 - 2 answers

Excel: Pivot tables with Line Graph with outside data

Excel Pivot Table + Line Chart Help [more inside]
posted by MikeyObviously on Oct 10, 2012 - 3 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

Need to finally become an Excel/Powerpoint ninja. But how?

I finally need to break down and school myself on Excel and Powerpoint. What's the best way to master them in the Bay Area? [more inside]
posted by foxy_hedgehog on Sep 14, 2012 - 4 answers

What are the dates for the 9th and 20th business day for the rest of this year and all of next year?

I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
posted by reenum on Sep 14, 2012 - 6 answers

Seeking on-line training in MS Office

Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg on Sep 4, 2012 - 8 answers

How to insert a bunch of links to an excel document?

How to batch insert links to an excel document? [more inside]
posted by Sentus on Sep 4, 2012 - 1 answer

Saving an Excel file with images as web page - why are thumbnails being created?

Saving an Excel file with images as web page - why are thumbnails being created? [more inside]
posted by davebush on Aug 31, 2012 - 2 answers

Pie chart in Word with dollar amounts?

How to make a pie chart in Word with dollar amounts, not percentages? [more inside]
posted by zardoz on Aug 30, 2012 - 5 answers

What is this type of chart called and/or how do you create one in Excel?

What is this type of chart called and/or how do you create one in Excel? [more inside]
posted by tippiedog on Aug 17, 2012 - 8 answers

How do I save to a text file in Excel 2011?

I'm on a mac. A colleague sent me an Excel file (.xls) which I looked at in Excel 2011. It looks fine. I would like to save the file in some sort of text format, so that I can open Terminal and look at it in less. I realize that the columns won't align nicely, that's fine. What I don't want are all the weird characters that show up (from differently formatted line endings, etc). I've tried saving as "Tab delimited text," but that has the problem with the line endings. Which format should I use?
posted by bluefly on Aug 16, 2012 - 9 answers

Validating data for data validation.

[ExcelFilter] Can I use one data validation list drop-down menu to specify which values will show up in a separate data validation list drop-down menu? [more inside]
posted by undercoverhuwaaah on Aug 15, 2012 - 2 answers

Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]
posted by hrj on Aug 9, 2012 - 24 answers

Work Pivot Table Magic...

Excel Pivot Table Help - My google-fu and excel-fu have failed me, I'm working on a tracking pivot table that will display total number of attendants in a class (broke out in gender) for each day based on a start and end date. [more inside]
posted by aggienfo on Aug 6, 2012 - 5 answers

There's a reason it rhymes with "hell"

Another "please help me find an alternative or a way to do this in Excel" question. [more inside]
posted by 2soxy4mypuppet on Jul 25, 2012 - 15 answers

Bringing business cards into 2012

Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC. [more inside]
posted by jonathanbell on Jul 23, 2012 - 5 answers

How to populate PDF form from Excel data?

How to populate PDF form from Excel data: number of copies based on number of rows? [more inside]
posted by GuppieXX on Jul 13, 2012 - 3 answers

Excel: A job for vlookup?

Excel help? I think this is a job for vlookup but I'm not sure. [more inside]
posted by stupidsexyFlanders on Jul 10, 2012 - 11 answers

Excel crash course

Can anyone recommend a great Excel course? [more inside]
posted by TKL0125 on Jul 7, 2012 - 2 answers

Info from Silverlight into Excel?

Can I get this information from a site on Microsoft Silverlight into Excel? [more inside]
posted by quadrilaterals on Jul 5, 2012 - 5 answers

Excel Manual

Im writing a manual for an excel tool I wrote. Does anyone know any really nice templates I can use or let myself be inspired by? I just need help on the aesthetic part ;) It's one of those manuals with pictures and screenshots too :) [more inside]
posted by freddymetz on Jul 2, 2012 - 10 answers

What are the best ways to increase Excel skills?

What are the best free and paid resources or training courses for Excel? [more inside]
posted by ramenopres on Jul 1, 2012 - 7 answers

Please help me create a calender on Microsoft Excel using dates in the spreadsheet from another tab.

Please help me create a calender on Microsoft Excel as I can't find any help online. [more inside]
posted by sockpim on Jun 25, 2012 - 3 answers

Excel help

I have an easy (hopefully) question regarding time formatting in Excel. [more inside]
posted by repoman on Jun 22, 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

html tables are killin' me.

How do I import tables from HTML into Excel when some cells have multiple lines? [more inside]
posted by KGMoney on Jun 14, 2012 - 6 answers

Excel copy/paste question

Probably a simple Excel copy/paste issue... [more inside]
posted by xedrik on Jun 8, 2012 - 5 answers

Conditional formatting, with limitations.

How do I set conditional formatting in Excel based on whether a list value has been selected in a range of other cells? [more inside]
posted by doyouknowwhoIam? on Jun 2, 2012 - 1 answer

Using formulae when I should be using VBA

Excel 2007 Filter: Is it possible to nest 3 OR statements in an Index and Match formula? [more inside]
posted by Ruthless Bunny on May 31, 2012 - 5 answers

Is creating a compound line graph possible with this dataset?

Is creating a compound line graph possible with this dataset? If yes, how? If not, how should I set up the data? [more inside]
posted by chillmost on May 31, 2012 - 3 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

Please help me get my Excel data back.

Earlier this morning, I accidentally deleted some columns of data on an Excel spreadsheet and then saved it. Is there a way to get those columns back? [more inside]
posted by soundproof on May 16, 2012 - 4 answers

Condition Excel... And Repeat

Excel Filter: Advanced Conditional Formating, Format based on type of formula used (average, sum, sumproduct etc..) [more inside]
posted by MechEng on May 7, 2012 - 5 answers

Excel function for consolidating a bunch of rows of nearly identical data?

I need help sorting out a bunch of data in Excel where the row data is almost identical except for one column that I need to retain. [more inside]
posted by marylynn on May 3, 2012 - 13 answers

Method Range of Object Global failed

I'm starting to write some Excel-VBA Macros, but it seems I don't get some basic things. I tried this simple code: [more inside]
posted by SweetLiesOfBokonon on May 2, 2012 - 4 answers

Options for labelling an axis when graphing with Excel

Excel graphing question: Is there a way to change the axis labels to something you are not graphing? [more inside]
posted by jb on Apr 27, 2012 - 10 answers

Need VBA help to refresh and save worksheet.

Have Excel 2007. I would like to have a spreadsheet perform the following simple? tasks [more inside]
posted by bleucube on Apr 22, 2012 - 3 answers

Excel keeps unreferring my references

Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
posted by jeather on Apr 18, 2012 - 2 answers

How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other?

Excel help: How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other? [more inside]
posted by quodlibet on Apr 17, 2012 - 6 answers

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