Skip

866 posts tagged with excel.
Displaying 151 through 200 of 866. Subscribe:

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

How to determine relationship between two dimensions of a 3 x 3 frequency matrix?

Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel? [more inside]
posted by Susurration on Apr 10, 2012 - 10 answers

Why can't spreadsheets work like brains?

Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right? [more inside]
posted by frecklefaerie on Apr 6, 2012 - 7 answers

Should I turn these simple programs into *apps*?

Dear Chaps, I have two products, an Excel spreadsheet and a Filemaker Pro database. The excel spreadsheet is for sale to mortgage brokers. It's the kind of thing designed for a user to enter figures and get all kinds of graphs and information based on the data entered. The other is a contact manager database, again designed as an easy-to-use program for the end user. Does it make sense to turn these products into iPhone/Android/Cloud-based apps, and what would be the next steps in doing so? In other words, what exactly would I be turning them into, and whom would I outsource this job to, if it makes economical sense?
posted by DesmondDoomsday on Apr 4, 2012 - 4 answers

Stinky Linky!

Is there a way to define a link by the number of links into the webpage it is? [more inside]
posted by ian1977 on Apr 2, 2012 - 2 answers

How do I create an amortization table where my payments change every period?

Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique? [more inside]
posted by lea724 on Mar 29, 2012 - 16 answers

Why don't they teach us how to prep the numbers as well as how to crunch them?

ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
posted by smirkette on Mar 26, 2012 - 10 answers

How to get Excel to search multiple files?

How do I get Excel to search through multiple files and extract data into a separate worksheet? [more inside]
posted by panboi on Mar 26, 2012 - 9 answers

Manage my Finances

Does anyone else manage their finances in excel? How exactly do you do it? I would like to manage my (pretty straight forward) personal finances. Alternatives to excel welcome. [more inside]
posted by bruinbruin on Mar 17, 2012 - 19 answers

How do I make a dartboard-type chart for the web?

I made an awesome dartboard-type chart in Excel, but now I'm trying to put it on the web. Help!! [more inside]
posted by snapped on Mar 16, 2012 - 5 answers

Dumb Excel question

Excel-Filter: I am using Excel 2011 (for Mac, if it matters). I want to create a simple X-Y chart of two columns. That's it. Should be simple. But I must be missing something. [more inside]
posted by vacapinta on Mar 12, 2012 - 3 answers

EXCEL QUESTION LOL

I have a data set of user activity. It records every time an activity is completed by a user, with the date and user ID attatched. I need to tally up the number of times, by user, the user completes the activity on a unique day. [more inside]
posted by Patbon on Mar 5, 2012 - 13 answers

Need some pointers on creating a simple inventory database

Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
posted by smoothvirus on Feb 22, 2012 - 8 answers

Help with Excel formula and table

I need to a formula that will calculate accumulated points based on the number of sales an employee had during a quarter, when there are certain milestones he or she has met. [more inside]
posted by desjardins on Feb 21, 2012 - 8 answers

Can a sortable spreadsheet exist in a PDF?

I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]
posted by Servo5678 on Feb 17, 2012 - 5 answers

Don't people do this every day?

I want to do something ridiculously simple in Excel that doesn't seem to be possible. Please tell me that's not true. [more inside]
posted by cincinnatus c on Feb 10, 2012 - 17 answers

How can I create a sheet for each row in Excel?

ExcelFilter: Is there a way to create a sheet for every row in Excel? [more inside]
posted by monkeymadness on Feb 9, 2012 - 15 answers

Comparing Excel Sheets for Sanity and Such Things

ExcelFilter: Compare rows for data changes? I want to find out whether row values are different between two sheets on records that match. [more inside]
posted by kensch on Feb 1, 2012 - 6 answers

Excel SUMIF function - what condition am I looking for?

ExcelFilter: how do I get SUMIF to work so that if a cell in the reference range is blank, the corresponding cell in the sum range is picked up in the sum? [more inside]
posted by sillymama on Jan 31, 2012 - 5 answers

How can I force Relative Cell References into a Conditional Formatting Forumual in Excel

In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]
posted by willnot on Jan 30, 2012 - 6 answers

Mail merge decimal woes

Mail merge woes - how can I get these decimals to display properly? [more inside]
posted by mai on Jan 30, 2012 - 8 answers

Excel woes - automatic sums including dates?

In Excel, is there an easy way to make the sum of a column automatically ignore cells that contain date information? Also, is there a way to freeze both the top row and first column so they are always visible? [more inside]
posted by Kutsuwamushi on Jan 18, 2012 - 14 answers

Help me break Excel to my will with a perfect formula

An Excelfilter question, because I cannot for the life of me figure out how to do this without getting an error or making Excel crash... [more inside]
posted by yasaman on Jan 12, 2012 - 20 answers

Don't select what I selected, select what YOU think you should select!

Help me understand how to make a macro do what I want it to do - automatically select the relevant area instead of a previously recorded cell range. [more inside]
posted by komara on Jan 2, 2012 - 6 answers

Excel is the death of me!

I have about 200 separate Excel spreadsheets that I need to change one field in. There is a date in G4 that needs to be the same in each sheet. Is there way way to do this without opening, editing, and saving each sheet one at a time?
posted by keep it tight on Dec 19, 2011 - 10 answers

scraping pdf content?

I have about 4000 pdfs that i need to scrape data from and put into a database. [more inside]
posted by buttercup on Dec 11, 2011 - 8 answers

When control-v seems too obvious...

Excel skills required for a particular job… I'm not sure what they are asking for. [more inside]
posted by anonymous on Dec 6, 2011 - 9 answers

Make Excel stop babysitting me.

Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help? [more inside]
posted by ootandaboot on Dec 5, 2011 - 9 answers

Excel for People who don't know anything

Excel issue. Tried looking on the internet, had no success. Can y'all help? Selecting and deleting multiple nonadjacent rows. [more inside]
posted by crush-onastick on Dec 2, 2011 - 18 answers

How to prevent accepted tracked changes from carrying over into an excel + word + outlook email to 50 people?

Hi everyone, Hoping someone can help me sort this problem ... It's a excel + microsoft word document + mail merge to outlook email to 50 people. I am trying to help someone out - this is is as it just as it was described to me: Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails. ..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings! Sorry if this is too vague. Thanks for your efforts :)
posted by anewnormal on Nov 30, 2011 - 3 answers

Excel Macros For Dummies

Explain to me Excel macros and how I can learn to program them (assume that I know absolutely nothing, because that would be correct). [more inside]
posted by so much modern time on Nov 30, 2011 - 8 answers

Weighted regression?

Excel statistics question (linear regression with weighted data points) [more inside]
posted by dabug on Nov 30, 2011 - 9 answers

Free online graphing app that plays well with Excel?

Asking for a colleague: "Back in October 2008, I found a free online app that uploaded data from Excel and produced (very pretty) charts and graphs. Unfortunately, I didn’t keep track of the website, and I’m having trouble tracking it down again. Most of the free graphing apps I’ve found online today require that you manually input the data; I’m looking for something that will more easily upload a set of data from Excel."
posted by lassie on Nov 22, 2011 - 5 answers

Can I create pivot table from subset of data?

Can I create pivot table from subset of data? If not, is there another way to do what I want to do? [more inside]
posted by Diablevert on Nov 20, 2011 - 6 answers

Help me become a spreadsheet power user

How do I become a spreadsheet power user? And do I have to get Excel to do it? (Or can I stick with LibreOffice/Google Docs?) [more inside]
posted by Busoni on Nov 19, 2011 - 10 answers

Excel Find and Replace

Excel - Find and Replace -- I use the excel function find and replace often. One spreadsheet finds it instantly. Another searches each cell and takes longer. I stopped updating the instant one before I noticed the effect. Windows xp -- Office 2007 I'd like to have more of the instant search.
posted by notned on Nov 18, 2011 - 8 answers

Excel formula help

Help me write an Excel formula to extract specific data from a list? [more inside]
posted by genesta on Oct 26, 2011 - 8 answers

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