Hi, i'm having the hardest time trying to transfer data from one sheet
to another sheet.  The data that I receive comes from different sources
and are always in different order, however, the column name is always
the same.  I wanted to transfer only the columns that I need to ...

is there a way to stop a cell being recalculated when useing the now()
function ?
e.g if(a1="order",c1=now(),"")....but i dont want the cell updated after its
inital value is obtained.

Here's what  have and need to do...
Sheet1
A                   B                  C               D
# of weeks     RoomType     $Charged   Yes/No

I am currently trying to get data from a pivot which has this form
Sum Count       Block
                      False        True     Grand Total
item1                   4             4               8

I am new to Pivot tables.
I have created a table successfully with totals and grand totals. All
works well.
What I am trying now to do is add a formula that calculates the % of

I am trying to develop a spreadsheet to plan production batches and I require is a formula which takes a start time, adds a number of hours and displays the projected finish time. Foe example if a job is started at 21:00 on tuesday and takes 16 hours I need the sheet to display ...

What formula can I use to get 1st, 2nd and 3rd number most occuring in a
column? I am looking to count ballots for 1st, 2nd and 3rd place win of a
contest.
I use Excel 2000

I have inserted several combo boxes into my form. I was able to populate the
dropdown lists by entering the name of the cells (product) in the 'List Fill
Range' on the properties menu of the combo box.  I was wondering if anyone
knew of a way to use a formulas in that field?  I ...

Does anyone know if there's a formula to not just count words, but to
trim the number of words in a cell to a certain number (say 5)? So, if
the previous sentence were entered, I could get back "does anyone know
if there's", and the rest would be truncated. Any help is greatly

Take the following formula:
=IF(R2450="calc",
IF((M2450-L2450=0)*(G2450<P2450),DATEDIF(A2450,G2450,"yd"),
IF((M2450-L2450=0)*(G2450>P2450),DATEDIF(A2450,P2450,"yd"),

Column A is Cities, Column B is States.  Column C is Dollars.  There
are 200 rows of information.  I want to add the values in Column C if
the City is Wichita and the State is Kansas.  Can sumif do this??

I am trying to average a range of cells which sometimes includes blank
cells, which returns: #DIV/0!  This happens when the entire range is
blank, but works fine when data is present.  I would also like for it
to display "NO" instead of #DIV/0!

I need to view two worksheets in the same workbook simultaneously, but excel
won't let me open the same workbook twice for side-by-side viewing. How can I
do this?

Is there any way I can choose which worksheet opens when I open a specific
workbook? I know it will open to the last sheet saved, but neither I nor
anyone else who uses my workbook can ever remember to return to (for example)
worksheet 1, before saving and closing. Can I not ...

I have a sheet where I enter in numeric values around a range of cells
(B1:D3). I want to be able to acquire the cell address of the max
value.
For example: