Skip
##
858 posts tagged with excel.

Posts

##
858 posts tagged with excel.

Displaying 351 through 400 of 858. Subscribe:

## Excel Noobery

ExcelFilter: I need to write something pretty simple in Excel. I have big spreadsheet of data. Some rows are fill-colored, and some columns are fill-colored. I need something that will show me (hopefully in a table or something) the cells that have their entire column colored AND have their entire row colored. Returning the value of the cell would be helpful too. (I have a feeling this is an embarassingly easy question to answer)

## Help me so I can Wait for it... EXCEL at my job!

Help with Excel 2003... More inside: [more inside]

## Help me edit named ranges in Excel 2008.

Mac Excel 2008 Question: how can I change the edit mode when defining named ranges? It's not F2, it's not CTRL-U, so what is it? [more inside]

## Using Excel Formulas to Rank Ordered Lists

Excel question: I have a list of values, sorted from lowest to highest. I want to rank them. But I have a specific issue with regard to ties, and I'd like to be able to craft an Excel formula which will deal with this automatically, if possible. Full explanation below the fold. [more inside]

## If I add a percentage to a number, how do I find the original again?

In Excel, adding percentages, needing to correct, and having to get back to the original amount. Can I do this? [more inside]

## Excel Checkbox Dilemna

Excel Checkbox Question. Please help me write a macro that will selectively uncheck certain boxes within a named range. This has driven me crazy all day today. [more inside]

## Excel: What column does this value appear in?

Excel: How can I find the column that a value appears in? [more inside]

## One to Many Renaming & Copying

Looking for a utility to take a single original file, and make multiple copies of that file with different file names, pulled from a list. [more inside]

## Using Excel to create the body of an Outlook e-mail

Complex Excel question - need to select a range of cells, based on the selection of a separate cell. But wait, it's more complicated than that! [more inside]

## Excel Filter: Search the contents of one cell for the contents of another cell, then replace with the contents of yet another cell? Is it possible?

I need to search the text in column A for the text in column B, replace it with the text in column C, and return the new complete string to column D. I've Googled. I've read. I've cried. Can you please help me? [more inside]

## The cake is not a lie, if we know you deserve it . . .

Excel date puzzle - looking for a simpler solution, ramblings follow [more inside]

## A graph for all to see.

How do I get an Excel-generated chart onto Facebook? [more inside]

## Excel rounding of number

Is there a way to force MS Excel to always give you four significant digits when rounding a number? [more inside]

## Getting Excel to reconcile two types of data

Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily? [more inside]

## Can you recommend online tutorials for Excel, Word, and MS Access?

Can you recommend online tutorials for Excel, Word, and MS Access? [more inside]

## Standardize my comment size

Is there a way to standardize 'comment' window sizes in Excel?

## How do I plot a comparison of points to the normal curve in excel?

How do I compare a scatter of points in excel to a normal curve? [more inside]

## Escelfilter: Making a dummy worksheet to simplify display of information?

I have a massive spreadsheet that's simply too difficult to read, because of its size. Is there any way of making a second spreadsheet that is exactly the same as the first, except that the 2nd's cells just show an "x" if there is information in the 1st's cells. i.e., the 2nd spreadsheet would just show whether or not the cells on the 1st spreadsheet have been filled in, but not the actual information itself. If sheet 1 looks like this, sheet two should look like this. [more inside]

## Column-oriented CSV in Python?

Is there a simple, elegant way to iterate over columns in CSV files using Python? [more inside]

## Another GD excel question

Another, once again, excel question on fill colors [more inside]

## Excel lookup same day different date previous year

Quick Excel help? Need to retrieve this day last year based on date input by user [more inside]

## How do I bring HTML data into Excel?

I once used a web-based spreadsheet tool that let me copy data from pretty much any webpage into a properly formated spreadsheet. Upon pasting an entire page worth of HTML-formatted search results, for example, it prompted me for the desired cell arrangement in the spreadsheet and applied it to the entire set of data. I can't remember what it was called, I can't seem to google the right terms and this will save me (not to mention my employer) countless hours copying and pasting data this week and next. Alternatively if you have another solution, please share.

## Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.) [more inside]

## Blind Spot in my Excel Formula Abilities

Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]

## Word 2007 formatting question

How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]

## I've just spent 16 hours on a lab. Never again.

What spreadsheet/graphing software should I use to do physics labs? [more inside]

## Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number? [more inside]

## Need help making an excel formula

Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries. [more inside]

## Type, copy, click, paste, type, copy, click...

I've been manually sending out emails about test results and then entering them into a database - is there a way to automate so part of this process? [more inside]

## Slow typing in Excel 2008 and unexplained network traffic

Why would Excel 2008 cause a lot of network traffic while typing in a cell? [more inside]

## Need help developing a Excel VBA Macro to Vaildate data entered into a textbox

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]

## Is it possible to do a global change-style in Excel?

Is it possible to automate a citation style change on an entire column in Excel, or do I need to do this by hand? [more inside]

## Save me from my excel hell

Another GD excel/csv filter [more inside]

## MacgyverFilter: link sharing using MS Office

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using ~~bubblegum and string~~ the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]

## excel gets my goat sometimes

excel filter: why wont it let me have header rows below row 1? [more inside]

## Hide rows in excel if two cells match.

Please help me create an excel macro to hide rows given a certain criteria. [more inside]

## -6+6*6 = 25. No, that isn't right...

Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out. [more inside]

## How can I take a picture, organize and create a URL for each SKU in a mini-warehouse?

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse? [more inside]

## Excel: Incrementing Formula Row Copied Across Columns

Excel question: I need a

*row*number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside. [more inside]## Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]

## How to return every Nth value in a column in Excel?

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column. [more inside]

## Evaluate the meaning of a string in Excel.

How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside. [more inside]

## Conditional Formula Selection in Excel

How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? [more inside]

## A Program to Help Me?

I started a new internship, and I'm wondering if there is some way to automate copying the non-profit information from this website. [more inside]

## Help me with an Excel AVERAGEIFS problem

Excel help with AVERAGEIFS: I need to generate an average figure per row, but the cells to be averaged need to meet two criteria. [more inside]

## How can I force Excel 2007 to save as a single html file?

How can I force Excel 2007 to save as a single html file? [more inside]

## How to set Excel2003 to automaticall include file name and path on printed spreadsheets

How can I set up Excel 2003 to automatically include the file name and path on every spreadsheet when printed? [more inside]

## Know any good VBA tutorials?

Can you reccommend VBA tutorials, particularly for MS Excel 2007? [more inside]

## Trouble calculating regular averages in Excel

In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]

## Your chance to help education reform in a third world country

Help! My job requires IT knowledge I don't have. Two questions. [more inside]