Skip

878 posts tagged with excel.
Displaying 301 through 350 of 878. Subscribe:

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

DOUGHNUTS!

PowerpointN00Bfilter: How do I use the graphing functions in PP and Excel to simply display 2 columns showing two different values of x% of something? [more inside]
posted by broadway bill on Aug 1, 2010 - 2 answers

Excel Short cut Question

Excelfilter: This may be a long shot, but..... Is there a quick way of formatting a table to group like records under a single heading? [more inside]
posted by Kurichina on Jul 29, 2010 - 14 answers

help me Excel

Passing an MS Office test with flying colors. [more inside]
posted by anonymous on Jul 26, 2010 - 12 answers

An unscientific method?

ExcelFilter: Help me avoid scientific notation when importing a .csv file. I face the same problem faced by "Mark" in this article. Is there a solution to this problem that does not require changing the file extension? I am using Excel 2003.
posted by bgrebs on Jul 22, 2010 - 11 answers

Spreadsheets, Databases - Help Me. Please.

Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses. Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API. This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program? Thanks in advance.
posted by watercarrier on Jul 21, 2010 - 15 answers

How does one auto-fill an Excel spreadsheet with terms?

How does one auto-fill an Excel spreadsheet with terms from another data source? [more inside]
posted by Fiasco da Gama on Jul 20, 2010 - 9 answers

Please help me create charts to analyse my self-tacking data.

How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist? [more inside]
posted by razzman on Jul 19, 2010 - 6 answers

Windowing problem in Excel

Windowing problem in Excel. [more inside]
posted by Bruce H. on Jul 14, 2010 - 5 answers

Calculating interest rate

Excel-finance future value help please.... Google Spreadsheet inside. [more inside]
posted by yoyoceramic on Jul 13, 2010 - 4 answers

YTD total based on sum of last number in another row that has a value?

YTD total based on sum of last number in another row that has a value? I need to sum up the values in one row based on the matching row below it. For example, if I have a target of $1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul. I have tried a couple of variations on COUNT, INDEX and OFFSET. Example is here: http://malcommc.com/ytd.xls I am using Excel 2003
posted by malcommc on Jul 12, 2010 - 12 answers

HTML Table to Excel to CSV

I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
posted by jontyjago on Jul 10, 2010 - 7 answers

Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

Please help a data analysis amateur!

How to sort to count yes/no answers.... In Access or Excel. Help! [more inside]
posted by BusyBusyBusy on Jul 6, 2010 - 16 answers

There can be only one (Excel formula I have to update)

Excel guru filter: I want to change this formula every week, and have the change cascade across 20 tabs of independent data. [more inside]
posted by deludingmyself on Jul 3, 2010 - 7 answers

Copy & pasting from Excel into Word

Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello on Jun 29, 2010 - 5 answers

Excel Merging Rows Help

I have an excel 2007 spreadsheet that has 4,000 rows and 6 columns of information. Need help merging some of the rows together..... [more inside]
posted by bleucube on Jun 23, 2010 - 10 answers

Excel 2003 ... is an update making this product non-functional?

Why doesn't excel 2003 work on my computer anymore? [more inside]
posted by candasartan on Jun 19, 2010 - 6 answers

Correlating dates, times, stock movements

I have lists, in Excel spreadsheets, that contain perhaps 500 rows of data in three columns: Date, Time and Stock Ticker Symbol. I need a method to correlate those three things with unusual stock activity. In other words, if column 1 is March 10, 2010, and column 2 is 10 a.m., and column three is INTC, I need to know if something unusual happened - high volume or big price movement - for INTC around 10 a.m. March 10. Anyone know a program that'll do this?
posted by Flunoid on Jun 17, 2010 - 11 answers

Help me help Word and Excel play nicely together.

I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
posted by anderjen on Jun 10, 2010 - 5 answers

Where to find a database of all movies made?

Is there a relatively complete movie database in csv or other Excel-friendly formats? [more inside]
posted by AmitinLA on May 31, 2010 - 3 answers

Save me from having to hire a data enterer.

Bah! Help me deal with my difficult excel data! [more inside]
posted by masterscruffy on May 28, 2010 - 12 answers

Basic and not-so basic excel questions

Excelfilter: Okay, I'm confident that this can be done in Excel, but I don't know how. Basically, I have a set of samples for which a value (size) was measured at various days. I need some formulas to tell me when the first and last values were measured and what those values were (for each sample). [more inside]
posted by kisch mokusch on May 26, 2010 - 9 answers

Have paragraphs. Want just the hyperlinks. In Excel.

Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
posted by randomname25 on May 19, 2010 - 10 answers

A text based pivot table

Excel Assist/I don't believe I couldn't figure this one out: I have a table with unique text values. How can I have it act the same way as a pivot table? Sample inside. [more inside]
posted by yoyoceramic on May 17, 2010 - 9 answers

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