I have a spreadsheet that uses some user defined functions.
I have included in the code application.volitile, so they recalc when the
workbook needs calculating.
They are public functions and are located in module1.

I want to be able to have a count of entries and be able to total entires per
month depending on what unit they are from.
Example:
Date       Unit    Savings

I have two workbooks which have the same data in 5 cells in a row
across a  but in cell a the name is different
would anyone know how to match criteria by 5 cells being identical in
a row to another workbook ?

This works:
   CONCATENATE(RC[2],"Rating")
But this does not work:
   RANK(Rate,CONCATENATE(RC[2],"Rating"))

I have a data stream with a variable parameter (Y) measured at irregular
intervals (X).
I am using Excel 2003. How do I resample my data to produce parameter values
at regular X intervals?

I made a function, this function returns a value that i would like to put in
a certain cell.
In a cell you can put for example =now() then the field is filled with the
date and time.

Is it possible to use VLOOKUP and COUNTA in the same formula? I want to find
a value with VLOOKUP and then I want to count entries in column up to and
including value found with VLOOKUP.

I am reposting my question in this forum, as i didnt get any reply from
anyone for my post couple of days back, i dont know wats the reason;
I have to limit the weightage of value not more than 15%, this would be used
as benchmark weight, a

I am using office 2007 and have a formula in column F which states IF(E4=" ",
" ", E4/A4).  This keeps the column formatted throughout the worksheet.  I
now need to identify using conditional formatting, any cell which is greater
than 15% and less than 15%.  When I choose this ...

When I have a column or row of cells "auto summed" at the end I want to be
able to hide certain colums/rows in that sequence and have the hidden cell
values automatically deducted from the sum.  Is that possible?

I have 2 worksheets with long lists.  Each list has additional columns with
data, but not found in the other.  I want to compare and merge items listed
so all data in all columns are combined in separate worksheet.

I am setting up a layout or template on the main (master sheet) sheet. All
other sheets on the same workbook will have the similar layout. The question
is, what can i do so that whenever i add additional table/s on the main
sheet, it will automatically update the layout for the ...

What is wrong with this formula?
=IF(AND('Node 01'!A1:A1000=A22,'Node 01'!B1:B1000=B22),'Node 01'!H1:H1000,0)
Looking at "A" and "B" for a match and the anwser is "H" the same row as "A&B"

I have a sheet which looks as follows
Sheet 1
COl A  l  COl B          l COl C                              l COl D
Name  l  Tax            l Tax Recpt No                    l Date of

I have a bunch of cell with varying lench that have numbers at the beginning
(also of varying length. Ex:
1258 ahjKJ yuUIOI
45687045HJKoiuwER