Using Excel 2007 and XP Pro SP2.
I am using a VLOOKUP formula which is working fine, however I have about 20
worksheets within my workbook each containing unique values (same data
ranges however). Is it possible to change the worksheet reference in the

or doesn't work right when I use freeze panes.  Maybe it is due to too many
tabs in my worksheet???

Need syntax to show first 3 letters of last name and first letter of first
name. Also if last name only has 2 letters, need to add a Z on end to make 3
letters.

Hi, our legacy system keeps dates in integers in form ccyymmdd.
I've long known how to convert, in Excel, a datetime to a number.  One
example is:
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))

I have a worksheet that has over 2000 rows and every 4th row I have a number
that I am trying to sum up. Currently I understand that I can not have more
then 30 variables in a function so I take 30 rows at a time then sum up the
results and adding them up. Here is what I am using ...

help,
if error.type(column C) is <=7, i want the value of "0" returned.  otherwise
i want the value in column B returned. the formula i'm using in column D is
IF(ERROR.TYPE(C1)<=7, 0, B1).  i'm getting the desired "0" value if there is

I imported a set of Color Functions from http://cpearson.com/excel/colors.aspx
And I want to replace where I added COUNTIF in my sheet with a new function
that will count in the specified range, using the specified criteria and if
the color is red.

I am trying to count just the number of "No Reasons Provided on the
Execptions tab and it counts all the reasons fot the vendor.
Using the below formula I get 5 instead of the 3
Vendor    Registers    Reason

Hi, i am looking to drag my calculation across cells in excel.
I have a two page set up.
Calculation in cell 1, sheet 1 = 4 cells across on sheet 2
I want to drag the formula across my cells on sheet 1 so that

Hi
I created a worksheet with some cells which work out network days etc from
some date columns everything working fine.
I sent the spreadsheet to a colleague and when he opened it it looked fine

I'm using Excel 2003 and having a prblen with the border lines.  The border
lines show up when I hit ok.  I then view the sheet on print preview an dthe
lines are there.  Then I save the sheet and the lines just disappear.  The
funny thing is, is that the border lines save and ...

i have 2 columns of cells.
column ONE is numeric (1,2,3,etc)
column TWO is text (group, trip, etc)
what forumla can i use to make column TWO to be plural based upon whether

We are trying to automate the printing of a worksheet.  In sheet
"Jobs" of the workbook it has consecutive numbers in column A (1,
2,3 ...) and is variable.  We would like to automate the insertion of
each consecutive number from this column A into cell C6 of the Summary

I have a list of number  for example 10Numbers
P0    60
P1    65
P2    70

I am using a shared spreadsheet in Excel 2003 SBE and the option for
hyperlinking is greyed-out. I should have full functionality. The cells
aren't locked. What am I missing?