I have a monthly data:Feb-04-Feb-05 Feb-04 2,156 ..... Dec-04 3,844 Jan-05 3,964 Feb-05 4,001 I need to make a forecast for Jun-05,Jul-05,Aug-05 Which of...

My worksheet has 50 rows showing sales for each book. It has 39 columns - 3 for each month - budget, actual and diff - and 3 more columns for YTD. They are...

How can I have excel: 1) search a specific row, e.g R4:R500 and for every occurance of a non-blank cell 2) bring back what corresponds to that row in col...

Can you password an Excel worksheet, if so how?

Can you auto fill down a column to repeat vendor names all at once.

I have created a spreadsheet to be used by others in which they will input their monthly data. So many of you have helped me put this thing together--I am...

Does anyone know how to generate a unique card number based on a previously existing number? I'm trying to create a 16 digit Check number by only given the...

I have a large spreadsheet that has four columns. Whta this spreadsheet is contains the number of customers in each area and each breakdown of the hour. What...

Xcell has help screens for many functions like CUMPRINC. However, they are not recognized as valid functions.

I want to keep track of my hours, and multiply it by my payrate. Is there a tutorial or somewhere where I can learn how to make a sheet where I can put in the...

I have a list of 3000 names from 3 diffrent lists. (Accpted, declined, open) I want to get a list of all the declined names that also appear on the open or won...

I can provide my assignment in Finance class that I am stuck on. My email is

I have changed some links in my spreadsheet and now after I update the links I get a dailog box saying "This workbook contains one or more links that cannot be...

Is there a way to design user specific pivot table layouts? Can you save those in the pull down menu?

I have a an eight week cycle working shift pattern. What I want to do is be able to have a mock template of the days of the week and when I enter the week no...

Hi, I'm looking for a method to find the previous row for an item, eg: ! A ! B -----+-----+------------------ 1 ! 0 ! Kurt 2 ! 0 ! Jan 3 ! ...

Is it possible to sort data by the frequency in which a number occurs instead of ascending/descening? Currently I sort by a column which is currency so that...

NEED FORMULA PLEASE I have a file with 6 work sheets. I would like to take the totals of the first five work sheets and have a gtand total on the 6th work...

Have spreadsheets with up to five individual workheets. Some have as few as three, but most have five. Need to cut-and-paste all formulas into values for each...

Hi Folks. I have 2 columns of info, 'A' contains quantities and 'B' contains product name. The same product appears multiple times in column B, with a...