Hi is it possible to calculate the number of months and the remaining days
between 2 dates, i.e
Date 1 is 1/16/07
Date 2 is 6/10/07

I'm very (very !!!) new to Excel, and have Excell2007 on my pc.
I know that i can "Sort" a column either ascending/descending, but if have a
row of data going across the worksheet thats all related eg:
Surname  Firstname  D.O.B  Address  Telephone etc etc

I have the following table (more or less 1000 rows):
Code1     Code2     Number1
510          632          48
.            .            .

My program uses office 2003 excel template and opens it up in Office 2007
excel application. When it is first exported and open all macros works fine.
User saves open excel sheet in compatibility mode (that is macro enabled).
When this saved excel sheet is opened again then ...

I want to be able to count say "dog" if listed in one column if a "tick" or
yes/no value is entered into a second column in the same row position. i.e.
if the customer is "a" and we met delivery, so "yes" on the same line, count
1.

Ive got Max A:A, which returns the maximum number in column A. How can i
get another cell to show the data from column B, which is pulled from
the same row as the result of Max A:A.

I am trying to combine countif functions.
I want to check the total number of times that while b2:b100 equals 36, and d2:d100 equals 1.
Thanks
EggHeadCafe.com - .NET Developer Portal of Choice

how to link excel worksheets with a reference (indexed) key field in each
worksheet

I am trying to use a double array. I need to use it on a pivot table result,
so I need first to check the date matches before it does the standard array
function. I can get the standard array working, but when I put in
=(IF($I$3=$A$5:$A$1200,SUM(IF(F5=$B$5:$B$34,$C$5:$C$34)),0))

I have the following data set:
Month   Item   Salesperson
Jan     B         AA
Jan     B         AA

I have a bar graph with two different axis.  When i graph the bar
graph in Excel, the bar graph overlap each other with one in the
foreground and the other in the background.  How can i make them
standing side by side each other.

qst for excel ninjas...
is there any way (addin or other) to do ctrl + tab (first in, first
out history) with excel sheets?
Any tips for navigating sheets? I find it a pain to have tabs on the

I need toi get a value or message in a cell if a row of the sheet has a the
same number more than one time.
Is ther any function I may use?
Than you for helping.

Does anyone know the pre-defined keyboard shortcut to right-click on a sheet
tab to bring up the sub-menu (insert, delete, rename, move or copy etc..) ?
Kind Regards,
Bhupinder

I am getting crazy trying the following:
row 1 cell A1 =hlookup(A2:F3;max(A2:F2);1) (closed with shift ctr enter)
row 2 cells  23  25  43  10  0  12  25 (as results of sum(A4:A50 - B4:B50 -
etc.)