Is it possible to solve this with only formulas, no coding?
data is organized in this way:
B    C      D
M1  K01  1

I am trying to make a Validation drop down list with the list source a set of
data from an advanced filter. I can make an extra worksheet to put the
filtered data in before using it as a source for the drop down list. But I
was just wondering if anyone knows of a way to do this ...

I used to use a function where a formula would look in a cell to find what
column or row it should use in the formula. Anyone know what this is callled?
Thanks,
KW_Counter

=SUMPRODUCT(--(W2:W31="TS"), --(Y2:Y31="B"))+SUMPRODUCT(--(W2:W31="TS"),
--(Y2:Y31="D"))
After trawling the pages of Messr's Mcgimpsy and Pearson and others the
fromula above works perfectly but I can't believe it needs to be that

There is a need to validate a cell to insert only from 9 digit number to 13
digit number.
For Example:       000000001  to  9999999999999.  ( I want to ristrict the
user to enter even 8 digit number i.e. 99999999)

I have data comming in to an excel file from Access. Once in excel the
spreadsheet does it's thing providing minor breakdowns with various
countif's, sumif's and graphs etc. I am new to the Sumproduct, the following
is a sample of the data. I am, in this case looking for the ...

Hi................
I have created a macro and want to run that macro in all the excel
files.
But to that I have to open the file that contain the macro every now

I can not get the sumproduct function to work properly. I have read a number
of threads and followed the example to a tee, but function will not work.
Here is my problem. I have two colums both on another work sheet. I would
like to count the number of records based on two ...

I need to know if certin forms are out of date. This is a piece of the table
below.
Start Date    Duration Expired Yes/No
1-Jan-07    13   

They seemingly do not work as anticipated.  I'm probably misinterpreting
something.
=SUM(($B$3:$B$1000=M4)*($C$3:$C$1000=$AH$2)*(OR($F$3:$F$1000<>0,$J$3:$J$1000<>0))*($H$3:$H$1000=1))
The OR section is what I am having trouble with.  This formual returns

There is a need to validate a cell to insert only from 9 digit numbe
to 13
digit number.
For Example:       000000001  to  9999999999999.  ( I want to ristric

I am trying to get a formula that will do the following:
a score of:
0-9 = normal
10-13 = mild

Folks,
Need some help here. This is the problem - need to solve in Excel.
John will enter college 6 years from now, and spend 4 years in
college. The current annual cost of college education is $25,000 and

Hoping that you can all put your heads together and help me on this
problem.
I want to create an IF function that will look up a column of DATES
and insert an amount in another column only where the date is (say)

I have numerous subsets of data listed by Day: 1st - 31st & Month: Jan - Dec.
Is it possible to provide a single Formula to reference a large group of data
containing some miscellaneous rows that should not be reflected in the data
returned. I would like a flexible Formula to ...