Here is  a sample of my column cells contents:
2DO, 5DI  (this data is in one cell)
1DO, 2DI
AI

I Have a worksheet which I am adding rows to as i get information in.
One of the columns is country, what I want to do is countif so i know the
number of times that a country appears. Basically I am using a simple countif
formula in the adjacent cell to that specific row but ...

Hi,
I have a database containing approximately 25 workbooks with hyperlinks to
each one, and a huge number of formulas that also refer to these workbooks. I
need to transfer the database to another computer but maintain the integrity

Can I view my header and footer on the normal page view?  I can view it in
the print preview but would like it to be visable on the normal page view?  
If this is possible could someone please tell me how I can make it visable?

Using the right mouse button is working fine in rest of the Office 2007 suits
and also in Excel 2007 Charts.

Here is an example of what I am trying to lookup:
column A   column B   column C
3.00          4.00          2.95
3.00          4.50          3.00

how to access the sheet tab options only by keyboard like deleting sheet,
protecting sheet etc.
--
Rajesh Chandra

I have a problem with making a pivottable from my data with visual basic.
When running the code visual basic says that there is an invalid procedure
call or an invalid argument. The part of the code that is wrong according to
visual basic is the uppermost part(from beginning till ...

I EVERYONE.SORRY MY ENGLISH.
I WANT TO NOW, WHO CAN GET IN EXCEL 2003 THE FORMULA, TO ALLOW INPUT THE  
DIFFERENCE BETWEEN TWO DATES, AT THE DAY WORK WEEK AND NOT WEEKEND!!!I TRY,
BUT MY EXCEL DONT HAVE THIS OPTION.

Good afternoon.
I have an Excel 2003 spreadsheet which has several thousand rows of customer
details.  In many of these rows the first columns (A-M - which contain name,
phone number address etc) are duplicated however the data contained in the

Help.... when using the above formula, how can I transfer figures from
another spreadsheet without losing the decimal places . ie a figure of 125.40
transfers as 125.4 and 123.00 transfers as 123.
Thanking you in advance.

This may sound a little silly, however, the field that I use to type
information into (so it transfers the copy into the selected field), has
disappeared and I don't know how to retrieve it. For example: if I have a c
ell with, say, 20 words typed into it and one word is misspelt ...

I have another question to ask from a previous question that I posted a
while ago, I have included my prev question and it was as follows:
"hi,
-my question is basically for example if u type a value of 50 to lets say

hi community
for inserting of worksheet, I can use keyboard shortcut by press Shift+F11,
how about deleting worksheet, is there also a keyboard shortcut?
can help?

hi community
after i select a cell and filled up with 1 shade color, say "yellow",
is there a shortcut besides using the Format Painter, to use like keyboard
keys where when press it will give me the same shade color, "yellow", in