I MADE A SPREAD SHEET TO TRACK JOBS THAT WE BID. I SET UP ALL THE FORMULAS SO
ACCOMADATE 1500 JOBS. THE PROBLEM IS THATS 31 PAGES AND I DON'T WANT TO PRINT
ALL OF THEM  UNLESS THERE'S INFO ON THE PAGES IS THERE ANY SETTING OTHER THAN
"SET PRINT AREA" SO IT WILL ONLY PRINT WHAT ...

I'm new to pivot tables.
I wanted to have one pivot table column that counts the entries in a
data column AND another pivot table column that sums the values of the
same data column.  Excel doesn't seem to let me put more than one copy

I am sure this is an easy answer for some of you, but I am not sure how to do
this...thanks for your help in advance.
I have an average formula that I would like to dynamically change the number
of rows it averages.  For example if I have 25 cells of data, but the user

Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???

I have been studing the early formation fo trig tables by Ptolemy abotu
100-200Ad.  I now would like to know the methodolgy tht ecel uses for
calculating these functions.  I'm not interested in the detailed code, just
the general methods.

I have two columns of data. Column "A" houses Numeric Labels and Column "B"
houses Numeric Values.
Data:
Numeric Labels A20:A105

I have a spreadsheet that has 42 tabs, 1 for each week. I want to be able to
enter names on lines in the 1st tab and them automatically enter on the same
corresponding line on each additional tab. Each tab contains the exact same
spread sheet. Can this be done?

in my vlookup formula, I am finding values that shouldn't have values are
returning the value for the closest match.

I am working with hugh spreadsheets ( 80+/-  columns by 3000+/- rows),
I have to take other workers spreadsheets and make a master copy.
The other folks do not track their additions, deletions or updates to their
spreadsheets. Hugh problem.

I'm trying to build a workbook from project plan that keeps a running total
of actual hours.  The only problem I'm having is with this summation
question.  Numerous employees are entering their weekly hours for the current
week.  How do I build a function that adds current weekly ...

in my vlookup formula, I am finding values that shouldn't have values are
returning the value for the closest match.

I have a dropdown validation list. When I select an item from this
list, the rows below will be populated using the HLOOKUP function. The
HLOOKUP function brings the values from the other sheet. The records
will be one to one thousand. And I have the formula upto 1000 rows.

I have a simple problem that probably requires a simple answer:  I have a
range of values in two columns and a third column that contains the value I
want.  The ranges NEVER overlap and are unique.
For example:

Is it possible to group and hide colums in an Excel workbook across multiple
sheets at once without having to group and ungroup colums for each page?  I
have a workbook with thirty sheets that I use to keep track of 25 peoples
production during a month.  If a person leaves, I ...

Hi, I want to return the words/ string of words after the last divider "/".
e.g. in Column A, there are
Society/Education/University/USA
Society/Education/University/USA/University of Chicago