I have a list of data with three columns, these are 'Period', 'Area' and
'Cost'.
I want to pivot to show the area's listed down vertically, the period
horizontally across and the 'Grand Total' inserted in the pivot table to give

Userform1 adds data to the database as such,
       A            B           C           D           E          F        
     G
1  PICKID     NAME    START    FINISH               PICKS        DATE

PLEASE HELP!!
I am trying to do tier pricing on a worksheet.  This is the help that I
need.  If someone orders 5-50 boxes the price will be $50 per box, 51-99
boxes the price will be $48 per box, 100+ boxes will be $46 per box.  Can

I have entered into a spreadsheet many lines of data using one line per
person to include information for that person. I wish to be able to select a
person by number and then print that persons data onto a form with the data
in pre planned positions on the Form, aAlso I would ...

i have a lot of attributes to set up.
most of them only differ in another suffix: for example:
attribute1_suffix1
attribute1_suffix2

I have a problem with external links on Excel 2007.
More specifically, I have a spreadsheet that is linked to external data from
Bloomberg.  After updating the information on a Bloomberg Terminal, I would
like to use the spreadsheet on a normal PC (not Bloomberg Terminal ). The

Dear Sir,
I have following two columns as
-Date------Code
02-06-07----10

I need to figure out how to calculate from an original date obtained to the
next date obtained? How do I calculate this?

hi community
scenario:
i have 5 worksheet, name as, Jan / Feb / Mar / Apr / May,
and

Hey guys need help on this formula as I keep getting a #REF! Error that won't
list what is required from cell AN15. The formulas below are as follow.
Cell C7
=IF(ROWS($1:1)<=COUNTA(B$15:B$47),INDEX(B$15:B$47,MATCH(LARGE(AM$15:AM$47-ROW(AM$15:AM$47)/10^10,ROWS($1:1)),AM$15 ...

Employees are eligible for benefits the first day of the month after 60 days
of work.   Example: An employee starts working today 6/26/07; her benefits
are effective September 1st., which is the first day of the month after 60
days of work.  What formula I can use to come up with ...

I can figure out how to get my pivot table to give me a count of items, and
sometimes I can get to the option of having it display percents, but how do I
get it all to happen at once?  I'm used to working in SPSS where I can create
a crosstab with row percents, column percents, ...

I would like to create a formula that equals one cell if a selection of
others include certain text.
For example, A1 is H, B1 is HI, B2 is HHI.
I want my formula to equals A1 if cells E8-E10 contain the contents of B1 or

I have a spreedsheet that contains 4 columns of similar information.
In the pivot table I would like for it to search all four columns and
do a count instead of just one column.
ex.1

I have a list set up as follows:
          ID#            COMP                     PROF#            YOE
12345                   ACCOUNTANT              1                  3
12345                   SYS ANALYST              1                  5