I have posted a question on here before relating to this issue but I can not
now find my post so you will forgive me if you are re-reading this.
I am trying to create a rota for my staff who work 24 hours a day, 7 days a
week.  I do not want to include dates on the rota (due to ...

Column B of my workbook contains names (more than 500 rows). How do I find
(macro or worksheet function) if a name has been entered more than once.
Thank you.

I have to check two columns to determine if I pull the sums from a third.  So
I need a sumif formula that accepts two criteria.  For example:
I need to get the sum of values in column C where column A=Account 1 and
column B=Cost Center 2 (answer in this case would be 2,000):

How do I prohibit outlines from forming on Excel files?

I am a new user.  I would like to present my scenerio in hopes of
getting a formula figured out.
I have three columns.  
The first column represents a due date (mm/dd/yy)

I am newbie here and is having hard time in doing this.
I have an excel workbook which has two sheets Grp1 and Grp2
within these sheets i have unit and id columns, what I am trying to d
is find out the combination of unit and id column which is on Grp1 bu

Is it possible to look up a string of text within another string of
text, using some variation of vlookup? For example, I may need to find
a text string like "First Bank" within a column containing strings of
text that may be "The First Bank" or "My First Bank" or some variation

One of the Excel users here at UM has encountered a bizarre problem.
He is generating a report from our accounting system which he paste
into an excel spreadsheet. He is using VLOOKUP to get data from th
pasted report which is used to update MTD and YTD accounts.

I am trying to find a function that will allow me to calculate the difference
between two dates.  I want the answer to be shown in months only, therefore I
would need any additional days to be converted to a decimal.  I tried to the
datedif function, but it does not recognize ...

Here is my scenario:
**Column 1**       **Column2**
John Doe                Jane
And this is what i want it to look like:

I have Excel 2003 SP1.
Version 11.6355.6408
I have a cell with the formula:
=COUNTIF(A1,"x")

Hallo everybody,
I have excel sheet with email functions in the panel tools. There are
buttons for send email, to choose who is recipient, to whom will be send via
copy etc... There is fully integrated mail function and sheet look little bit

I am trying to set up a database for life insurance premiums. Basically, the
rate is 10 times the expense constant plus 36 dollars. The expense constant
is different for each age. The formula I am typing in looks like this:  
=(10*10.65)+36.  The 10.65 in this example is the ...

below you can see a table devided in months and weeks.
In every week there can occur an event, here called "A".
Question:
How can I count in how many months an event happens.

okay, i have 1 workbook with 4 sheets.  Sheets names are say,  sheet1
sheet2, sheet3 and sheet4.  
on sheet4, i want to create a formula that will pull rows B2 to H2
from sheet1, B2 to H2 on sheet2 and B2 to H2 from sheet3  (it will be