hi, trying to test 2 colums, of 1 column:  has either of 2 criteria..
=SUMPRODUCT(--(AQ233:AQ2000=AQ232),OR(--(AA233:AA2000="p0"),--(AA233:AA2000="p1")))   not quite working
singularly, does work:  (but need to test for "p0"  or  "p1"),  thanks
 - how to OR()  a sumproduct..

hi, I am trying to find if record exists for values met in 2 different
columns, for use in a conditional format.
info have is:
=INDEX(ROW($AQ$1144:$AQ$1228),MATCH(TRUE,$AQ$1144:$AQ$1228=$AQ11,0))>ROW($A$1144)

I have data in the same area (E8..E57)on multiple (22) worksheets. I need to
copy these 22 columns into one worksheet displaying each column separately.  
Now I can copy the first column into the destination worksheet, but can I
copy that column so that worksheet reference changes ...

I am having some trouble using the frequency formula. All I want it to
do is to read an array of decimal numbers and a bin array and return a
proper frequency value. But all I get is a 0. I have used the CTRL +
SHIFT + ENTER keys and it still doesnt work. Here is the data

The sheet I am working with has a column of ~150 names (A2:A151).  A1
has the title "Names".
The 27 cells to the right of A1 (A1:A28) all have their own name based
on specific criteria.

I can not for the life of me figure out why this button is greyed out. I've
looked all over the web and I'm sure it's a simple solution. If anyone has
any advice why my design mode button is greyed out let me know. Thanks

I am not able to find it anywhere to download.  Do I need to call MS
or something?

You know how you can freeze the top row?  Yeah.  I'd like to freeze a
chart that I have on the sheet, so that I can scroll the data, while the
chart is locked in place.
I am using Office 2007.

I have a  long list of names in the validation database, so scrolling through
the entire list takes a long time.
Is there a way to set up the name find so that as a user starts to type in
the first letters of a name it automatically goes to the right name?

I am trying to filter on the last three days of a running report (dates
always changing in a twenty day period) in a macro.  Because it is a macro, I
cannot reference a certain date (Dates change but the macro won't).  How can
I write this, any help would be appreciated.

First of all, where is the add-in.  I can't find it.  Once I know where it's
at, can move it so that I can access it more easily?  Thanks in anticipation!

How do you filter dates to show the last date or the last three dates in a
spreadsheet relative to the current dates on a spreadsheet, meaning without
actually entering a specific date?

I need to be able to save and close individual worksheets within a single
Excel workbook.  Is there a way of doing this?

Is it possible to close a .csv file while you are in .xlsm. Here is my
situation, I have a .xlm file and a .csv file open at the save time and I
would like to run a macro that closes the .csv file. My problem is I can not
give it specific file name to close because .csv is auto ...

How do I create a formula that would show when somethign expires.  For
instance I have a spreadsheet siwht lots of dates and want it to show me
possibly in red which ones are expired so I can better track these items.
Thank you.