I have two Dynamic Ranges: "ACTUAL" spans 7 Columns and many Rows. "FORECAST"
is one Column and many Rows.
I would like to check if the numeric values in the LAST Column of  "ACTUAL"
match the values in "FORECAST" on the same Row. If there is a match on the

On worksheet tab 1, I have a list of numbers (col a) ranging from one to
twenty and a dollar value (col b) assigned to each. On the next
worksheet tab I have a list of names in col a and when I put a number
on the next column, I want col c to go to the first worksheet and give

im not the best at my formulaes when it comes to excel, im on a tria
period for a I.T company and ive been asked to come up with a formule.
heres my problem, 2 different values in collum a,5014 & 5015, now basi
formula is

=IF(ISBLANK(BU25),"",'SL 2'!E24) This function works.
=IF(ISBLANK(CK24),SL!E24,JL!E24) This function works also.
I'm not really sure where to go from there. I need to combine these
functions and add on based on the senerio that I have outlined below.

This seems so silly that I can hardly believe that I need to ask, but
...
How can I use my Named Range "PctOverall" (an overall % complete number
stored in the worksheet) in a macro?

I need to pull from 4 different sheets within the workbook based on whether
1,2, or 3 reference blocks are left blank. If block one is left blank then
the sum should be blank but if it is not blank then the sesult would vary
depending on whether or not one or more of the other ...

I am running 2 columns to do accumulated totals. I have a formula such as
this: Cell b2 = a2+b1,
Cell c2 = b2+c1 ect.
I want to hide the accumulated totals until the cell in column one gets a

This formula is very involved and I am not sure what to use.
Basically whether (BU25) is blank or checked determines whether or not the
rest of the formula should be used or if the field should be left blank.
Next, whether (CK24) is checked or blank determines whether the value ...

I need to format a cell so that if it stays blank, the cell is red.

I'm analysing a power series (y = a*x exp(b)).  After analysing the data in
Excel, I re-ran the data in MINITAB.  The b's are the same, but the a's vary
by a factor of 20!  I need to reconcile these two results.  any suggestions?
Earl Eiland

I want to set up certain columns in my spreasheet so that all text entered
into it shows in caps

OK, I am not sure how to even begin to search for this because I am unsure of
the nomenclature I need to look for. That said, here is what I am looking to
understand:
I need to display a value of "1" if a total (manually entered in an adjacent

This formula
=SUMPRODUCT((MONTH(AO9:AO272)=1)*(AM9:AM272))
sums up the weight per month.  How would I sum up the weight per week--the
weeks ar entered in anywhere between 1 week and 15 weeks....ie  add up all

I need some help with a formula:
I have a list of weights and the dates they were received.  i need to find
the total tonnage for each month....and the average for each month. i.e. sum
all the weights that were received in jan, then feb, etc.....

I am aware of the VBA approach to identifying Cells with formulas. M
question,
is there anyway to use a Excel Function with logic to identifying
cell that contains