I have a data file with 50 columns, including one named "location". There are hundreds of locations, with values including '01', '21', '71'. I also have...

I have a row with data added daily, newest on the top. Then I have a formula which calculates some output according to the last three inserted cells...

I am designing an Excel spreadsheet as a template for data entry. I would like the cell to only allow two decimal places to be entered. For example, if a...

In older versions of excel the ' character could be used as the first character in a cell to mke the following character repeat itself throughout the cell. ...

I have a mail merge routine that I only use once each year to print my Christmas card envelopes. It pulls the addressing info from a spreadsheet and it uses...

I have to manually update cell references in text boxes as data shifts (across columns) daily in a separate workbook. Is there a way to automatically update...

I am hoping there is an easy way to get excel to shade all even rows in a work sheet that have data in them (as the range will vary from week to week). I...

Without complex visual basic is there any way to hyperlink from an Excel 2007 cell, to slide number in a Powerpoint presentation?

Thanks, everybody. Guess Ill name my worksheet "his tory" or something like that. Maybe that'll work - or not!!

1. There seem to be several third party ones out there; however, they also vary so greatly in price that one wonders if either the cheap ones are junk,...

Hello, I have ran into an issue with Excel 2003. Problem: I am formulating Unique values from a column and counting them on an Excel app. Issue: I noticed...

Which is the maximum number of elements to calculate a mmult function without problems?

i am trying to create a countif statement that allows me to use two variable- I have data in rows 1-1000 I would like to countif Column A=x and Column B=a...

How can I make a certain value in "column a" change something in "column b"? When a cell in "column a" is = "a" I want to change what ever is in the...

I have an Excell spreedsheet that does many wonderful calculations for patient medications which change frequently. I would like to export the single record...

I have an excel spreadsheet linked to an access database. When I attempt to do charts in excel I receive an error message which states not enough resources...

I've created an Excel spreadsheet to track monthly spending. There are 13 total worksheets -- one for each month and a summary sheet. Within each month...

Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does...

Dear MS Excel team I have a fundamental suggestion for the Find feature in Excel. When I open an Excel sheet it is shown in it's last state. That is also...

Does anyone have any suggestions on how to determine the value? There are two lists of number under column A and B. Example 1: I would like to determine the...