Visual Basic and Excel: How do I replicate the results of excel’s internal function for paired dual tailed t-test in Visual Basic. I tried and failed, where did I go wrong? [more inside]
posted on May 16, 2008 - 8 answers

I have no clue what I am doing in Excel, so this is going to be a bit hard to explain, but hopefully somebody can help me here. I want to give Excel some text, and have it output a string. Let me explain. [more inside]
posted on May 13, 2008 - 4 answers

Someone asked me if I could use Excel to take a table of information and put it into a new table randomly. Without thinking about it too hard I said "Yeah, I bet I could do that." Turns out I spoke too soon. [more inside]
posted on May 13, 2008 - 7 answers

How to tally votes in Excel? There is an Excel spreadsheet with many categories, with many votes per category. How do I get Excel to tally up the individual votes in a singe category? Each category is column, with the various votes per category listed as rows.
posted on May 4, 2008 - 21 answers

I'm using Microsoft Excel 2003 at work and I need to make a chart where the category (x) axis is the y axis; is there any way of doing this? [more inside]
posted on Apr 30, 2008 - 5 answers

I want to take an Excel spreadsheet and just make it a dynamically sortable table I can put in a webpage or blog. I want people to be able to click a column, and have the table be sorted by that column. Best solutions? Also, if the table included locations, is it possible to make them selectable, and have the selected locations display on Google maps? Thanks.
posted on Apr 26, 2008 - 5 answers

Any Excel gurus in the room? I have an Excel spreadsheet with over 800 rows of data. Each row begins with a number (like 0001), and some have letters after the numbers (like 0001a). The Sort function doesn’t sort the way I’d like it to. [more inside]
posted on Apr 17, 2008 - 7 answers

Is there a way to create a link in an Excel spreadsheet to a specific page or destination in an external PDF file? I've read some tutorials that show how to do this in html documents but can't seem to figure out if it's possible in Excel. I'm using MS Excel 2000 and Adobe Acrobat 8.1.2 Professional. Thanks!
posted on Apr 17, 2008 - 3 answers

Excel 2007 - Is there a way to remove ONLY a duplicate row leaving the first unique entry? [more inside]
posted on Apr 16, 2008 - 5 answers

I need a solution which will help me work out my revision plan automatically (Possible Excel filter?) Please help! [more inside]
posted on Apr 15, 2008 - 3 answers

Excel Filter: I can't figure out how to make Excel show my budget the way I need it to. [more inside]
posted on Apr 14, 2008 - 9 answers

Getting Excel to interpret text string as formula [more inside]
posted on Mar 29, 2008 - 7 answers

Is there a way to automate this very tedious spreadsheet task? [more inside]
posted on Mar 24, 2008 - 14 answers

Excel filter-filter: How do I set up an easily adjustable filter for a 7000-odd row spreadsheet in Excel Mac 2004 or 2008? The data's not well organised and needs to be filtered over multiple columns. [more inside]
posted on Mar 20, 2008 - 5 answers

Excel for Mac - Where the hell did my comments go!!?? [more inside]
posted on Mar 14, 2008 - 3 answers

Excel help: How do I make a chart which displays my values as bars extending above and below a particular line. [more inside]
posted on Mar 9, 2008 - 12 answers

We've got Census data in Excel from the Census Bureau. We've got a state all mapped out by census tract (using the unprojected boundary files, as they don't provide the projected files). What we don't have is a way to download values from the data files into the census tracts they correspond to. Is there some way to do this that we don't know? Will we have to write a program? [more inside]
posted on Mar 6, 2008 - 9 answers

Help me automate this task involving USB-disks, Excel, HTML and maybe a batch file. [more inside]
posted on Mar 5, 2008 - 5 answers

How do you figure out daily interest from an APR on student loans due monthly? [more inside]
posted on Feb 28, 2008 - 8 answers

How do I convert European dates to American in Excel? [more inside]
posted on Feb 25, 2008 - 3 answers

Can I alphabetize data in Excel (or elsewhere) while ignoring the articles "the", "a" and "an"? [more inside]
posted on Feb 20, 2008 - 10 answers

How do I add x and y axis labels to a chart in Excel 2008 for Macs? [more inside]
posted on Feb 15, 2008 - 2 answers

I would like to save an Excel spreadsheet onto the desktop of a computer for people to look at, but not to modify. I know how to protect the sheet to make it read-only or to require a password to modify it, but is there any way for me to prevent people from deleting it all together? I should add that the computer on which I want to have the file is running Mac OS X. Is there a way to make a file un-deletable? It is a public computer, so it must always be logged in under the same user name.
posted on Feb 12, 2008 - 12 answers

Spreadsheet design: I have to work with an Excel workbook that is driving me nuts... [more inside]
posted on Feb 7, 2008 - 13 answers

Rounding in Excel? [more inside]
posted on Feb 6, 2008 - 8 answers

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]
posted on Feb 5, 2008 - 4 answers

Finding and copying the first and last value, to the left of a range in excel. [more inside]
posted on Feb 4, 2008 - 6 answers

Can I program Excel to read a date in a cell, and when that date has passed, make Excel alert me by highlighting the cell or something along those lines? [more inside]
posted on Feb 2, 2008 - 8 answers

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted on Feb 1, 2008 - 8 answers

Excel 2003 - how can I get 2 or more xls files to open in separate windows? [more inside]
posted on Jan 30, 2008 - 12 answers

How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted on Jan 25, 2008 - 8 answers

How to "text to column" a cell with multiple lines in Excel? [more inside]
posted on Jan 24, 2008 - 7 answers

MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]
posted on Jan 24, 2008 - 4 answers

I'd like to create what amounts to a photo directory in Excel, and be able to sort by last name. Is this possible? If so, how? [more inside]
posted on Jan 24, 2008 - 6 answers

MS Excel filter: I'm editing a huge spreadsheet and Excel doesn't like my zip codes. How can I quickly fix this? more after jump... [more inside]
posted on Jan 24, 2008 - 9 answers

Excel 2003 question -- why do some of my cells show ####### in the contents? [more inside]
posted on Jan 22, 2008 - 26 answers

I'm an Excel idiot! Why won't my text boxes show that they have a solid fill? [more inside]
posted on Jan 19, 2008 - 3 answers

excel n00b question: why is paste special not working for me? [more inside]
posted on Jan 18, 2008 - 5 answers

Can someone help me come up with an Excel formula? I have a column, and each row in the column has a 9 or 10 digit number. I want to apply a formula that will recognize only those numbers with 9 digits and when one is discovered, it should place a "0" in front of the number to make it a 10-digit number. I will explain why inside. [more inside]
posted on Jan 16, 2008 - 7 answers

MS Excel question: Creating a master spreadsheet that dynamically updates when information is updated from any one of six other spreadsheets. Possible? [more inside]
posted on Jan 13, 2008 - 6 answers

Is there a way to format equations in Excel so they are more readable? [more inside]
posted on Jan 13, 2008 - 10 answers

How can I get data from the USDA's food database into excel? [more inside]
posted on Jan 5, 2008 - 8 answers

I want to simply my recording-keeping. Seeking an *easy* method for tracking multiple sources of income. [more inside]
posted on Jan 2, 2008 - 8 answers

I need suggestions for an application (or database) to help my employer keep better track of live-trivia scorekeeping results. They are currently doing it all in various separate Excel spreadsheets, and this is (almost) 2008, so I'm sure there must be a better way. [more inside]
posted on Dec 24, 2007 - 3 answers

I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below. [more inside]
posted on Dec 21, 2007 - 7 answers

Cleaning up imported data in excel using VBA. [more inside]
posted on Dec 21, 2007 - 1 answers

In Excel 2007, I need advice on how to round a series of prices to either a $0.50 ending, or a $0.95 ending. [more inside]
posted on Dec 20, 2007 - 10 answers

Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
posted on Dec 19, 2007 - 7 answers

How do I format the cell in Excel so that when I cut and paste a series of data derived from a formula onto a new sheet, it pastes the numbers, and not the formula? [more inside]
posted on Dec 19, 2007 - 7 answers

Excel/OpenOffice: How can I use XIRR to show an estimated percentage return based on account deposits/withdrawals/balances? [more inside]
posted on Dec 16, 2007 - 3 answers