This should not be a hard thing to do, but I can't get it.  the city will
always be the same with only 2 different zips.
Example: 1957 NE 6 ST DEERFIELD BEACH, FL 33441
             2430 DEER CREEK C C BLVD APT 702-11 DEERFIELD BEACH, FL 33442

If my data is cyclical in nature, what is the best function to use to
forecast my next year or two years of sales volume?  (I have higher volumes
in certain times of the year and I need to account for this when projecting
my sales.)

Is there a way to take this formula "=INDIRECT("'"&$P$3&"'!X9")" and
make X9 dynamic upon copying to other cells? For P3 I only need to
remove the $'s.
Thanks!

I have the following information:
Col A          Col B        Col C
Smith          Bill           (510) 424-5654
Johnson       Susan      (610) 566-5555

I was working and when finished tried to print my work showing gridlines
nothing showed on my sheet except plain workout without the gridlines tried
to go to tools clicked view checked gridlines clicked okay then tried again
but did not show the gridlines do not what i have done ...

I am trying to find a formula in Exel 97 so that I am able to find a text
value on multiple sheets in a workbook and it will return the name of the
sheet for me.  I have two spreadsheets open and want to find out what sheet/s
a cell reference is on:  example.  xyz is on sheet ?? ...

Is there a way that when you name a column that it stays in view if you
scroll down?
Also, what about doing the same thing with a row?
It would be nice to be able to scroll down and still see what column and row

Hi Group,
I am in "Microsoft Excel Data Analysis and Business Modeling." Chapter 42,
pg 342-343 and put the R squared value on a chart, which equals .9828. Then i
went to the functions and did RSQ, thinking this would give me the same

Looking for advice....
I want to create a calender by day/date/week/month/by half hour slots for
use in booking appointments in a hair salon.
Would excel be best or is there a better way of doing this?

I know it can be done but it escapes me at this stage.  Please help!!!
I have a spreadsheet which looks like
    A    B
1    Dog    12/7/07

Previous staff have form the function below and I don't understand what it
means. He was no more longer work here. I need someone to explain what it say.
Here is the function look like
=IF(ISERR(VLOOK($A7, returnall, 32,0)*100) ,“ “,VLOOKUP($A7, returnall,

I am linking two files by having cells in one spreadsheet equal to
corresponding cells in another. However when I enter the equal sign in one
sheet, then go to the other sheet and click on the corresponding cell then
hit enter, the original cell displays the formula, not the ...

i have several worksheets with the weeks as the title.  i need to change for
our new year.  Can someone please give me the code to change the worksheets
to add 7 days to each worksheet.  example 10-8 and 10-15 and 10-22 etc.
That would be very helpful

I have a sheet with lots of year to date data by month, the last column on
the right, which is AN, contains the abbreviated name of the month for each
row, formatted as m to show JAN, FEB,etc.    This sheet is updated daily for
year to date info.  I am trying to figure out an ...

I need a formula to to calculate the number of months an asset has been in
service.  For instance, In col C I have the date an assets was acquired
(12/1/99) and it has a depreciable life of 480 months.  I need a formual to
calculate the number of months remaining and the end date ...