I'm trying to use an array formula to calculate the weighted average.
Gross
A:10
B:20

Is it possible to have Excel to automatically add a 'comment' with the date
already in the comment to a cell when data is put into that cell?
tia

How do get Excel to number each row? i.e. 1, 2, 3

Anyone know what expression i need to use in a DSUM condition cell i
order to get it to filter the results on a month basis??????
I've posted in misc, but no one seems to know.....
--

Is there any way of highlighling non whole numbers from a list, ie. an
numbers with a decimal point,
Thank
--

As subject, data are in different color font or cell. Can I sum the dat
by different color? e.g. add all the data in red font and/or in blu
cell.
Many thanks

I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below
A            B

Frustrated here.
I have a workbook containing 3 worksheets.
Sheet1 lets a user enter all leads received.
Sheet2 has links to Sheet1 and provides a running total (based on dates) of

I am trying to use the offset function to pick out data from a seperate
worksheet. I use a variable in a cell that determines the location of
the relevent cells and found this works well.
My problem is that the offset function picks out the wrong data because

I have 4 columns, all the rows in the columns go together, example:
Branch:       ID:     Location:       State:
130           ADK     Adok Island     AK
120           JAN     Jackson           MS

I have created a drop down list and need to know is it possible to have the
data selected from the list shown automatically on another sheet within the
workbook?

I would like to be able to search a group of cells for particular text,
placing the true of false value in another cell, using this formula;
=IF(ISNUMBER(SEARCH("ACP",A2)),"ACP","XXX")
My reason for this is that I have a large amount of data that I need to

I have a spreadsheet where i have cells that asign a score of 1 to 10 to a
description by placing an 'x' in the appropriate cell, like this:
                                 1 2 3 4 5 6 7 8 9 10
description here                           x

Does excel allows me to create a condition and put in a comment in the cell
itself automatically instead having only true or false

I want to count the number of cells in column B, where two criteria is
true.
I.e. i want to count the number of cells in column B that equal
01/01/2006 where A7:A3000 = C7 and also B7:B3000 = 01/01/2006