I'm having a problem getting the right formula to give me a count of column D
by each type.  An example would be to get the total number of 319's in column
D with the following criteria.  Do not count if  "RON" is in B or C column
plus I have a lookup for certain cities that I ...

I've been working on a function to calculate how many quarters there
are between two dates - but not the standard business quarters -
effectively what I am trying to work out is the number of complete
three month periods between two dates.

Can I get Excel to tell me how many items in a column are
colored red?  I would just count them, but the column has
over 40,000 rows.

I have three columns of raw data which are x,y and z coordinates
("observations") for several different points, say points A to Z. The number
of points is variable as is the number of observations of any given point.
I want to group the data into blocks seperated by blank rows by ...

When my team tells me that their formula gives the wrong answer, I tell them
that they wrote their formula wrong, but this one...
I have a sumproduct formula that uses named ranges:
=SUMPRODUCT((hCountry=$B9)*(hIndustry=L$8)*hFees)

I have a data sheet that contains a list of footballers (soccer) names
(j4:j35). Each time they score a goal i enter a 1 by the side of there
name, then a 2 when they get a second etc.  In a second data sheet i
use data validation to allow people to choose anyone of these players

The exact command in Excel is case sensitive when comparing text.  It doesn't
have to be.  I can understand when comparing numbers or calculations.  
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

Help on function needed!!!
I made a sheet in which in col A there are parties name and in column
there are Vessels name, now in coloumn C named Remarks I want to give
comment of "Repeated" if any vessel name repeats in col B. Example-

I want to seach an array and return the element no of the first cell
that is empty. Vlookup does not work as it returns the value as opposed
to the element no.
I want to do something like Find except accross an array rather than

How can the color of the text inside the cell be changed automatically when
the logical result of the formula is “Yes” or “No”?  
Example: using the IF function. How can I change the color of text if the
result of the logical test is “True” and be changed into blue color if the

Please excuse the ignorance, I would search if I knew how to word what I
am trying to do. I have a grid of numbers and I want to enter 2 numbers
and have excel find where they intersect and give me the value in that
cell. As well the numbers along the top and side are 57-60 or 72-78

How do I set up a drop down box or calender on a spread sheet cell that
people can just click on and choos a date off a calender rather than just
typing it in the cell.

I have column A & B.  In column C I have =iff(a1=b1,"Y","N").  Now I drag
that down column c to the bottom of the list.  I might have
=iff(a150=b150,"Y","N").  Now I want to change a(row number) to a$(row
number) and b(row number) to b$(row number) for the whole column.  I know I ...

I have each months data seperated into multiple worksheets.  Now I need to
identify any entry that is duplicated and how often it is duplicated.  I need
the result to be ASA-2-145006 (2), ASA-2-305001 (2), ASA-2-305002 (2).  My
example data is below.  Any help would be ...

=VLOOKUP(M4,INDIRECT("'C:\MetalRisk\PriceData\["&AB4&".xls]Diffs3'!$B$3:$Z$1892"),$AB$3,FALSE)
The above formula works fine except that the file that contains the table
array has to be open.  The purpose behind my using the indirect function was
to specify the name of the file in ...