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

852 posts tagged with excel. (View popular tags)
Displaying 251 through 300 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)

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

Excel question

I have an excel sheet with the past ten years' worth of donors for a PAC. Currently Column A is a donor and Column B is a donation. Some of these donors have donated multiple times, so their names come up several times on column A. I want to set up the spreadsheet to automatically look for matching names, and then add up the amounts in column B and give me a total in column C. How to do please.
posted by nushustu on Jan 12, 2011 - 8 answers

Can excel save me money?

In Excel (or Google Docs) is there away to divide the value in a cell by the number of cells selected? So if I have a value of x and I then highlight 10 cells, each of the 10 cells would show x divided by 10. As I select less cells, the value in each cell increases because x is being divided by less. The main reason I want to do this is to show how much I'd need to save per month to reach a specific total.
posted by cubedweller on Jan 10, 2011 - 5 answers

How to automatically update one Excel worksheet from another?

Help with Excel! Is it possible to send specific information from one worksheet to another worksheet automatically? [more inside]
posted by Kutsuwamushi on Jan 4, 2011 - 9 answers

Excel sort for relative placement

I'm trying to implement a sorting algorithm in Excel known as "relative placement." Here's the setup: [more inside]
posted by philosophygeek on Dec 17, 2010 - 2 answers

Excel math puzzle

Excel question. Is there a way to determine a list of all possible values from a list that add up to a given total? [more inside]
posted by xedrik on Dec 14, 2010 - 4 answers

How can I find common words in two lists?

How can I find common words in two (or more) lists? [more inside]
posted by pantufla on Dec 13, 2010 - 9 answers

Excel changes cell colors on its own!

Why does moving a cell or cells in Excel change the background color in the cell it was moved from??? [more inside]
posted by Jackie_Treehorn on Dec 9, 2010 - 6 answers

Help me calculate a percentage contribution to a final total

Excel help: I want to multiply two numbers, then subtract a percentage from that number, and arrive at a fourth number. [more inside]
posted by Cool Papa Bell on Dec 8, 2010 - 6 answers

How can I compare the text in two excel cells for common terms?

How can I compare the text in two excel cells for common terms? [more inside]
posted by pantufla on Dec 6, 2010 - 5 answers

How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]
posted by teg on Dec 6, 2010 - 14 answers

Excelfilter: XML Mapping gone wrong

Excel 2007 Filter: I need to convert a text file to XML. I have an existing XML file that has the correct schema, but no functional xsd file. How do I get the schema from the old file to map to the data in the new text file? [more inside]
posted by ashirys on Dec 2, 2010 - 1 answer

How to merge & combine .pdf to Excel pages

How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]
posted by ~Sushma~ on Nov 30, 2010 - 5 answers

Outputting a hyperlinked list of documents in a folder with relative filepaths in Excel 97

So I am stuck at work with Excel 97. I am trying to do something that seems simple enough in my head but just isn't. Basically, I have a workbook filled with a bunch of worksheets. In some of those worksheets, I would a list of documents in a given folder with hyperlinks to those documents. I've managed to sort out a way to create a list of documents in a folder which updates each time the whole book is opened, but I really, really want that hyperlinked capability. More inside. [more inside]
posted by neksys on Nov 30, 2010 - 1 answer

Excel 2007 text to column help

Excel 2007 text to column help. [more inside]
posted by Ezrie on Nov 30, 2010 - 19 answers

Make 0.000 display as 0.000 and not 0 in Excel

Microsoft Excel Filter: When I type 0.000, I want the cell to display "0.000" and not "0". How do I stop all of this ridiculous autoformating in Excel for good? [more inside]
posted by nickerbocker on Nov 29, 2010 - 23 answers

Microsoft Acess Charts dead-end.

Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
posted by Jimbob on Nov 23, 2010 - 12 answers

Payments Along the Bell Curve

I need help calculating a construction interest payment schedule that is likely to follow a bell-curve. [more inside]
posted by jefficator on Nov 10, 2010 - 1 answer

3 green in March, 0 in February, 12 in January...

Yet another excel question - month + text criteria counting... [more inside]
posted by Seeba on Nov 10, 2010 - 4 answers

Help Me Convert Hard Copy Data to Excel

Scanning, Excel, data input help needed. I need to convert info from a lot of hard copy bank statements into a an excel spreadsheet. Have tried scanning directly into xls and it results in a disorganized mess. Have tried to cut and paste from scan created pdf but it will not allow. Please help in automating this process and making my life a much happier place. [more inside]
posted by mbx on Nov 10, 2010 - 9 answers

Paste a Formula into Non-Empty cells in Excell

Excel VBA Macro Help: I am trying to come up with a very basic script to paste a formula into any Non-Empty cells in the currently selected Range. but its not working. argh! [more inside]
posted by mary8nne on Nov 10, 2010 - 8 answers

How to get 'auto-complete' to work in an excel list being used to validate data entry?

Excel - How to get 'auto-complete' to work in an excel list being used to validate data entry? [more inside]
posted by therubettes on Nov 8, 2010 - 7 answers

Replacing the Microsoft Office "Ribbon" With a Menu

Microsoft Office 2007 filter: Can you recommend a program/plugin (or the like) which will replace the "ribbon" interface with a traditional menu interface? Free is ideal, but for-pay is okay, too. Running Windows XP. Thanks.
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2010 - 4 answers

Double a column/cell in Excel

Excel 2007 question: I have several cells/columns of numbers that I simply need to double. So 5 becomes 10, 9 becomes 18, etc. I'm an Excel n00b and can't figure this out for the life of me. Help! [more inside]
posted by zardoz on Nov 4, 2010 - 12 answers

How do I use nested COUNTIF statements inbetween Excel worksheets?

Excel Filter: If, Count and Sum functions, oh my! I need help creating a function that will search between worksheet B, and if certain conditions are met, count the sum of cells in another column (also in worksheet B) and return that result in column A. Mock Excel workbook enclosed! [more inside]
posted by VT@MU on Nov 3, 2010 - 9 answers

Don't have a row, Excel!

The short of it: avoid duplicates, show multiple sales in one row. I am trying to aggregate sales data on an Excel workbook, and it really isn't as complicated as I'm making it out to be. Maybe MeFites have ideas? [more inside]
posted by simulacra on Oct 28, 2010 - 16 answers

How to set up Indesign file for importing an editable Excel spreadsheet?

Wrangling Excel data in InDesign: When first creating a multi-page pricelist (which will need to be updated regularly), importing data from a 2000-odd row speadsheet, what should I be considering? [more inside]
posted by puffmoike on Oct 27, 2010 - 3 answers

What would you do with a BIG spreadsheet on a SLOW computer?

My very important spreadsheet has become too big to use without excel/calc slowing so much that I want to take an axe to the computer. Help! [more inside]
posted by pootler on Oct 22, 2010 - 20 answers

Data table sources with multiple pagination

i need to gather data from paginated tables and return them as a feed or something that can be easily pulled as a query into excel. [more inside]
posted by malcommc on Oct 21, 2010 - 4 answers

Copying Word tables into Excel without splitting cells into multiple rows

I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
posted by Dasein on Oct 18, 2010 - 8 answers

Map-plotting Software

Map-plotting / excel filter: I have precise latitude and longitude coordinates in excel for approximately 100-200 different locations. These locations are all located in a certain region of the U.S. What software can I use (free or paid) to populate a nice looking summary map with each of these locations? I need this to look presentable for client purposes.
posted by jameslavelle3 on Oct 14, 2010 - 5 answers

Project tracking solution needed

seeking a spreadsheet solution. I'm sure something like this exists, but searches have found templates that don't quite fit what's needed. [more inside]
posted by ChefJoAnna on Oct 9, 2010 - 2 answers

Exporting a Distribution List from Outlook to Excel

I need to export a distribution list from Outlook to Excel (MS 2007 in both cases). [more inside]
posted by joannemerriam on Oct 1, 2010 - 3 answers

Excel hell

Excel 2007 filter: How do you change the dictionary language for specific cells/columns/rows? [more inside]
posted by bethist on Oct 1, 2010 - 3 answers

How to use SUMIFS without crying

Can I use Excel 2007's SUMIFS function to do the following on a budget/finance report worksheet: Sum all of the transactions given a specific category AND a specific month. [more inside]
posted by man down under on Sep 30, 2010 - 3 answers

What makes Visio better than Excel?

What is the advantage of making a flow chart in Visio instead of Excel? I haven't played with Visio much yet, but I'm not seeing anything that's significantly better or easier.
posted by Caravantea on Sep 27, 2010 - 13 answers

Excel 2007 Conditional Formatting

Excel 2007 conditional formatting help! [more inside]
posted by rossination on Sep 25, 2010 - 4 answers

How do I "expand" time ranges in Excel?

How do I "expand" time ranges in Excel? [more inside]
posted by mpls2 on Sep 18, 2010 - 4 answers

Preserving grand total sorting with a value filter in place.

Is there a way to preserve grand total sorting in an Excel Pivot table when I've got a top 5 value filter on one of the columns? [more inside]
posted by undercoverhuwaaah on Sep 3, 2010 - 1 answer

Excel delimiters in one column

Excel filter: How to insert delimiters within one column?? [more inside]
posted by shotgunbooty on Aug 18, 2010 - 7 answers

Fixing broken links in Excel (when it's not in a formula

How do I find and fix broken links in Excel.... when it's not in a cell formula? [more inside]
posted by nyc_consultant on Aug 18, 2010 - 5 answers

Intro to Excel for Finance

Help me make a smooth transition into a new job in finance. I need to brush up on technical skills, most likely via excel. [more inside]
posted by Hurst on Aug 18, 2010 - 3 answers

Microsoft Excel or Substitute?

Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros. [more inside]
posted by mbarryf on Aug 11, 2010 - 6 answers

help me parse this range of data using excel, by number of events per time span...

help me parse this range of data using excel, by number of events per time span... [more inside]
posted by chasles on Aug 4, 2010 - 15 answers

iPhone app to open and edit Excel documents

iPhoneAppFilter: I have an Excel document on my home computer that I would like to be able to open and edit on my iPhone while I'm out and about, on an ongoing basis. The catch: app needs to be able to handle "index" and "match" functions. Without this functionality, the app would be useless to me. List of previous disappointments: DropBox (can't edit), QuickOffice (interfaces with DropBox but can't do index/match functions), Calc Lite (can't open document). I have zero programming skills and not that much more cash. Is my dream app (or combination of apps) out there?
posted by shortskirtlongjacket on Aug 2, 2010 - 8 answers

Excel filter: Nearest neighbor identification.

Excel filter: Nearest neighbor identification. Do I need a UDF? [more inside]
posted by sisquoc15 on Aug 2, 2010 - 8 answers

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