Hi, I have to find the difference between two dates, the first (and earlier
date) is in column C, cells C2 - C5910 and the second is in column H, same
row references.  The dates are in a dd/mm/yyyy format.  I have input the
following in column I - =DATEIF(c2,h2,"d") which I ...

I am sending this to several Excel newsgroups, because I am not sure
which one if the most appropriate.  I apologize in advance for the
multiple postings.  I have MS Excel 2000 (version 9.0.3821 SR-1).  How
can I format only a selected character or number within each cell in a

SORRY = here is the problem clearly stated:
A: filling in a Order Sheet
  1. coloum a2,3,4,5 will be the Quanities of each item
  2. column g2,3,4,5 will be the unit prices of each item

My workbook has 14 columns and more than 1000 rows.
Column C header is Last Payment Date and Column F header is Next Payment Date.
I need to DELETE all rows that has a different date other than 9/1/05 in
Column C and 10/1/05 in Column F.

I need help with creating a formula.  I want to count the total number
of individuals who meet a certain criteria in one column and a certain
criteria in another column.  For example: I want to find out the total
number of people who live in Germany and went on a specific trip.  For

How can Auto numbe an invoice I am working on in Excel. I use to be able to
do it in Office 97. View-Toolbars-invoice and then click on auto number. In
office 2003 I cant seem to do it. Any suggestions please?

About two weeks ago, my HP 1000 Laserjet stopped working in Excel.  It works
fine in all other Office and IE applications.  I have re-installed Excel and
the printer, still no luck.  I get a message that says that the "printer is
unavailable".  It won't let me setup the printer ...

I have a formula and I need to copy the result along side the cells the
formula is calculated from. Is there an elegant way to do this quickly? I
have to do it 200+ time!

is there? i can't seem to find one.

Background: I'm a instrument technician trying to use Excel to scale a
nonlinear device which streams a measurement (ultimately, force in
pounds) to a .CSV file. The Data is formatted as a raw, unscaled number
in one column and a adjacent timestamp in another column.

I would like to filter more than two items in my worksheet
autofilter and advanced filter do not give me this capability
What steps would  I have to take?
Thank you!

I realize that a workbook can contain more than one worksheet.  However
I need an  example of a spreadsheet application where it would b
necessary to have more than one worksheet and why.
allent

I am pretty familiar with pivot tables. I have fields that are counting, and
fields that are summing.  In my primary field I am summing and counting. How
can I get the grand total to count and sum?

I'm really hoping you can help me out here, I'm absolutely stumped

posts/tutorials on most of my queries - thanks to this site!
I am trying to create a custom function in VB to replace a 7 level

I am learning how to use excel properly and am trying to freeze panes. When i
tried to do it the other day i did it with no problems, today i am trying to
do it and every time i click on freeze pane i get a line down the middle and
a line accross the middle and that is were it ...