my function is
Code:
--------------------
   =IF(MONTH(TODAY())=(MONTH($H$4)),H6,)

I have searched hi & lo for any help on this, but drawn a blank so far.
I have data which I have combined from 2 cells to 1 cell. {see Example1}
{Example1}
ColA:                    ColB:

I need to have one cell in a sheet generate a random number without changing
after calculations are entered in other cells.
What I've tried so far:
=randbetween(111111,999999)

Im not sure this is possible, but im sure that this the place to tellin
whether it is. I am trying to create a tasklist for IT team. I a
creating a Tasklist on the first worksheet, this will show all th
tasks that need completing. Then on the next worksheets I am wanting t

I need a formula that can calc #'s giving totals: 1-15=1, 16-25=2, 26-35=3,
etc.
So that when I plug in say 9, in the first column, I get 1 as the total in
the next column but if I plug in 18, I get 2, etc.  This is for a school

Okay, I succeeded in combining the first and last names from two separate
columns into a new third column.  However, when I try to delete the unwanted
first and last name columns, all the data in the Full Name column is replaced
with #REF!

Hi - Please help if you know how to address the following required validation
in single rule.  I would like to prevent duplicates and limit the text entry
to 100 characters.  Is there a way to do this?
Assuming that my range is in C71:C100 I have the following but the length

Two situations:
1) Create two new workbooks
2) In one workbook (Workbook1) enter value of 200 in cell A1
3) In second workbook (Workbook2) enter [Workbook1]Sheet1!A1 into cell

i have this formula that i am using as an array , but it gives me an error
message. i am trying to use the formula on a page called "calculations".. the
information being used is on a page called "client"  .. i am also indirectly
referencing a cell "O1" on the calculations page ...

Why doesn't this formula work?
=IF(AND('Detail by POG'!D1:D1000="Mainline Books - 12.5'",'Totals
Only'!B3='Detail by POG'!B1:B1000),"YES","NO")
Thanks.

I am aware that you can evaluate two cells for equality using "double equal
signs" -- for example, by entering "=A1=B1" into cell C1 to test cells A1 and
B1 for equality.  Is there a way to use this "double equal signs" approach in
place of an IF statement?

I need to write a formula that filters out unique numbers in one colum
lists them in another, and then counts the number of times each o
those numbers appears  in the original and lists the values next t
them....I hope that meakes sense

I'm trying to convert a rather complicated formula into a custom
function.
Effectively, what the function does is it takes two values and uses the
worksheet function Match to locate the position of the values from a

What do {  } brackets mean when they encompass a function?
The following function, which works when the spreadsheet is opened, is in a
spreadsheet I inherited.  If you arrow onto the cell containing this function
it shows up just as shown below:

I have a list of birthdays in my Excel spreadsheet. I would like the cell
containing the date to change colour when the birthday is approaching (14
days before the date). To do this I have come up with the following to enter
in the Formula Is box..