828 posts tagged with excel. (View popular tags)
Displaying 51 through 100 of 828. Subscribe:

Related tags:
+ (188)
+ (86)
+ (67)
+ (48)
+ (47)
+ (45)
+ (44)
+ (33)
+ (30)
+ (30)
+ (24)
+ (23)
+ (22)
+ (21)
+ (20)
+ (20)
+ (20)
+ (18)
+ (16)
+ (16)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (11)
+ (11)
+ (11)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
zardoz (4)
willnot (4)
Anonymous (4)
FireStyle (4)
anastasiav (3)
goethean (3)
mwhybark (3)
Mr. Justice (3)
keep it tight (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
desjardins (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)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
digitalprimate (2)
Classic Diner (2)
sdis (2)
bibbit (2)
SheIsMighty (2)
Rock Steady (2)
WCityMike (2)
nickerbocker (2)
panoptican (2)
nooneyouknow (2)
furtive (2)
ObscureReferenceMan (2)
pwb503 (2)
Jimbob (2)
jessamyn (2)
dmd (2)
synecdoche (2)

[Excelfilter] How do I stop Excel from formatting my numbers?

I sat on the phone with Microsoft support and they weren't able to help me. I've scoured the internet trying to find a solution to this problem and I'm just about ready to give up. Can Metafilter rise to the challenge? How do I stop Microsoft Excel from formatting numbers into scientific notation? No matter what I do, Excel keeps doing this. Please make it stop. See the youtube video I made explaining my problem (45 seconds). [more inside]
posted by crios on Apr 16, 2013 - 37 answers

 

Help me reduce the size of my Excel file based on Sharepoint query.

I need some help with a situation where I have a bit of limited resources. Can you help me minimize the Excel file size while still keeping all data available for reporting use? [more inside]
posted by slavlin on Apr 15, 2013 - 0 answers

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]
posted by mwhybark on Apr 15, 2013 - 1 answer

removing links in Excel without losing formulas

I have a pretty large spreadsheet in Excel which I use to combine information from everyone in my department for monthly statistics. They all fill out the same spreadsheet, then I have links from all those to mine, with formulas adding everything up. I want to remove the links to one file while leaving the rest, without losing the formulas that contains the links. [more inside]
posted by timepiece on Apr 1, 2013 - 1 answer

simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel. [more inside]
posted by clockzero on Mar 26, 2013 - 8 answers

No, this isn't about EVE Online.

I need help taming a very long list of numbers into useful tabulated data, in Excel. [more inside]
posted by 256 on Feb 28, 2013 - 10 answers

Using Excel conditional formatting to do a name/ID data check?

I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside. [more inside]
posted by bibbit on Feb 25, 2013 - 4 answers

Need help with conditional lists in excel

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump. [more inside]
posted by FireStyle on Feb 23, 2013 - 9 answers

Another remove duplicates from Excel Q: Find the dupe, remove the ROW

So, Excel 2011 has a handy function for removing duplicates. Neat! Except that when it removes the dupe, it shifts all the cells UP, thereby ruining the relationship between the columns in the row. What I need it to do is this: -Look for dupes -IF it find a dupe, delete the WHOLE ROW that dupe exists in -Profit. [more inside]
posted by GilloD on Feb 20, 2013 - 7 answers

Excel auto-fill form on web page

I have an excel file with a list of phone numbers and someone requested that links be added, so that when you click on one, our text paging web page is opened and the "To" field is auto-populated with the pager number. Is this possible? I have no control over this text paging web page, but the input field for the form does have a name. This is the page: http://www.myairmail.com/ Thanks!
posted by jjbb on Feb 18, 2013 - 4 answers

Excel spreadsheet to pretty clips report?

I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc. What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to. I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.
posted by klangklangston on Jan 31, 2013 - 8 answers

Why won't Excel arrange its margins to what I want?

Excel 2007 will sometimes refuse to let me move its margins in print preview mode so that the document prints 1 page wide (despite letting me print that way previously on the document). How do I fix this? [more inside]
posted by lea724 on Jan 29, 2013 - 3 answers

Pinning Excel docs to the taskbar doesn't work with Office upgrade

So I upgraded from Microsoft Office Starter 2010 to Microsoft Office 2010. I uninstalled the Office Starter program. Then things went wrong. Please help! [more inside]
posted by merocet on Jan 26, 2013 - 3 answers

How do I figure out how to divvy out these projects?

I have roughly 20 people who each need a project. I have 27 projects and don't want anyone to share a project. I let the people pick their top five projects and rank them so I know who wants what. What is the best (easiest...) way for me to fairly figure out who should get what project so that the most people get their top choice, or at least one of their top choices? [more inside]
posted by pwb503 on Jan 22, 2013 - 8 answers

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]
posted by mammary16 on Jan 18, 2013 - 8 answers

Spinning, exploding Excel-driven web app: How or should it be?

Sometimes, I am a front-end web developer. Frequently, I meet new people at work who want to turn really complicated Excel documents into dazzlingly interactive web applications. Besides Excel's "Save to Web App" or "Save to SharePoint" features, such people ask if I can tap into an industry to support this -- perhaps scads of agencies and web-based or downloadable tools that make "websites" or at least customizable, interactive reports from Excel spreadsheets, data, and calculations. I'm yet to find this an abundance of examples of this. Are there? If so, what do you call them? [more inside]
posted by metajc on Jan 9, 2013 - 2 answers

How can I get access to readyState 3 with VBA "AJAX"?

I'm writing some VBA code (in Excel) which uses a reference to Microsoft XML, v6.0, and creates a MSXML2.XMLHTTP object. I used the clsXMLHttpMonitor example from this page as a starting-off point. How can I access the response text when readyState = 3? [more inside]
posted by jozxyqk on Jan 8, 2013 - 10 answers

Automated PDF modification

Is there an automated way of placing elements from one PDF file into another? Open to coding this via Python if a relevant module exists. [more inside]
posted by mnemonic on Dec 17, 2012 - 4 answers

Help me EXCEL at my new job. (Yes, I went for the obvious one.)

What books or websites should I look at if I want to master Excel? [more inside]
posted by synecdoche on Dec 16, 2012 - 9 answers

Comma delimited list to multiple lookup values in Access 2010

Is there an easy way of turning a comma-separated list into multiple lookup values in access 2010? [more inside]
posted by monkey closet on Dec 14, 2012 - 1 answer

How do I do this in Excel?

I am new to working with dynamic arrays in Excel. Also, I would like recommendations on books/resources for advanced Excel users. Help! [more inside]
posted by prunes on Dec 13, 2012 - 4 answers

How to jump to another Excel worksheet?

[Excel 2007 filter] Is it possible to input some text into a cell, e.g. "Click here for Worksheet 2" or similar, and create a hyperlink on that cell to open, uh, Worksheet 2? In the same window, not a new instance. Neither a search of AskMe and/or the Excel help-screens has been successful. Thanks in advance.
posted by aqsakal on Dec 12, 2012 - 7 answers

Why can't MS just add a watermark function?

How can I add a watermark to multiple tabs of an Excel spreadsheet, that can be easily updated each time a copy is printed? [more inside]
posted by PercyByssheShelley on Dec 11, 2012 - 3 answers

How can I propagate changes to formulas in Excel automatically?

How can I propagate changes to formulas in Excel automatically? [more inside]
posted by madcaptenor on Nov 29, 2012 - 8 answers

How to get millions from M in Excel?

Can Excel do input filtering or parsing of unit abbreviations? I want to be able to type "400M" and have the result be a number cell of 400000000, not the string "400M"
posted by fightorflight on Nov 29, 2012 - 10 answers

Converting lots of little excel into word?

ExcelFilter: I have a whole bunch of excel files. More than 100 of them. Each file has about one page of print area, but some in portrait and others in landscape. They are mostly text in cells; not a lot of formulas being used. I would like to (1) merge all these files into one Word document; (2) have a page break so that each file (more or less) is one page; and (3) do it with a minimum of cutting and pasting. Opening everything as a PDF and viewing in Preview is also an option, but less optimal since I'll certainly need to adjust some formatting and page breaks. Maybe on publisher? Is anything like this possible? Or do I need to do it page-by-page? What would you do? I'm on a Mac 10.8.2.
posted by RandlePatrickMcMurphy on Nov 19, 2012 - 9 answers

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

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