I need to look at a lead time in weeks from column B and locate that week in a seperate table - then sum the values in that table from the beginning to that...

How do I add time when the answer exceeds 24 hours, as the answer always seems to revert to under 24

My data set is a series of monthly returns (in percentages) for an investment. How can I go about finding which time period has the longest consecutive...

MEET NEW ADULTS NOW! FOR FREE AT - http://www.meetnewadults.com AGE VERIFICATION REQUIRED! http://www.meetnewadults.com 18+ ONLY! 100% FREE!

It seems, at least for me, that formatting cells to "General" is nearly impossible to maintain. I set a cell (or thousands of cells) to "General" format for...

I am attempting to use VBA script to match two columns of data. My problem is not the actual formula because I can do that, however; since the number of rows...

When I import text data into brings in spaces following the text...which doesn t allow me to center correctly. How do I essentially cut off the spaces...

How do I set up the trend function for the following? A B C D 1 2008 2007 2006 2005 2 ??? 12 ...

In excel 2003, when opening a workbook the following prompt comes up- "this workbook contains links to other data sources... update, don't update,help". I...

Hi, I have the following problem and don't know how to handle it. It might be partially connected to SAP. Can anyone help? I get export from customized SAP...

Hi I need Excel to count the unique appearances based upon two criterias. The columns needed is: Week Machine Order 40 1 ...

I have a list of company names, some of which were dummy companies set up for testing. those names are often things like 'dummy company' or 'test no.2 company'...

This formula gives me a error message every time I enter something in the worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula...

I have named in excel 70 cells - I have named them LAST1, LAST2,..., LAST70. They are in the same column, one underneath the other. I want to use the following...

Hello There is a rutine counting each week (very boring) I want to make it authomatic. I have an spread sheet which 4 columns are important: city, city...

I have several Excel workbooks that were originally created in Excel 2003 or earlier versions. Once I installed Excel 2007 early this year, I've been having...

Good day to all I'm having trouble figuring out which function i should use to find a certain range of numbers. First, i'll explain my problem thoroughly: In...

I can't use any excel function which contains a comma. This include IF, VLOOKUP, ROUND, etc. None of these functions is accepted even if I use the function...

I have a large matrix which many of that cells are empty or blank,when i subtract empty cells from a reference value for example B1000= 5, empty cells act as...

I put into Excel weekly figures (there change each week and time I put them in). I want to do a sum of the row at the end to generate a total. Doing this in...