I have recorded a Macro that runs correctly, but need it to run from an If
function after user has entered a particular word. Any help were be
appreciated.
Thanks Rosey

I am using a function to determine the name of the worksheet and place it
into a cell:  
=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,6)
I then want to use the output of this cell [the first one is 1001] to feed

I have a formula that reads  =IF(I135-J135=0,"OK","ERROR")
I can see that the figures in cells I135 & J135 are identical so I should
get a return of "OK" but I get "ERROR" instead.  Could be something to do
with rounding ? if so how do I amend the formula to cope with this.  (Note ...

I have 2 columns with data in them, basically representing a gaussia
distribution.  Column A has the "X-axis" values and so is uniforml
ascending with no duplicates.  Column B has the "Y-axis" values an
increases up to a maximum and then decreases again (this is data fro

 I am getting a #VALUE! error for the linked formula,  =IF('B1.1 &
B1.1.1'!E29:L29>0,"x").  
Please help.

I am trying to find the number of shirts by size for individuals in a fund
raiser. In a Pivot Table, Shirt size is in col. b starting on row 10, and
total contributed is in col. e. I want to put each shirt size in row 2 and
post the total for each in row 3 based on col e. being ...

I need to make a spreadsheet with formulas linking 2 pages together. The
formula is a IF formula and, going down the column, is in increments of 4
cells. ie: B4, B8, B12, etc. When I drag to fill the column with the formula
it automatically goes B5, B9, B13, B6, B10, etc. Hoy do ...

ive got a LONG list of details with the date entered as 12.12.2005
instead of 12/12/2005.  is there a way to change the . for a /
thanks
omneo

I have a column that we either enter “y” for yes or “n” for no to track
passing scores.  Is there a way that I can average the yes’ and no’s from the
same column?

I'm very new to Excel, so my question may seem basic.
I am trying to calculate one's current Age by inputting their date of birth.
I tried subtracting the two dates, but I get a date and I cannot format that
to an age.

Is there a way to dynamically set a range?  For instance... can I have
formula that includes a range (Ax:Ay) where I can set the values of
and y based on the value of another cell so that in one case, the rang
may be A1:A80 and in another it may be A50:A60 and so on?

I am using a Dynamic Named Range "Data", spans 55 Columns and many Rows.
I need a Formula to separately Index each Column of the Dynamic Range "Data".
The Numeric Criterion will vary.
The  Data is in Columnar Format.

Hi, i searched the forum and found a post on how to protect the
workbook, which is what i wanted.
"Try Tools -> Options -> Security tab
to assign passwords to modify or open the workbook"

I would like to extract matched data from one worksheet and put into another.
For example, a table contains two columns, country and city,
Country   City
CN          SZ

I have t-shirt sizes in col. B of a Pivot Table. A shirt is given to someone
who had deposited over $99. The deposit is in col. E of the same Pivot Table.
How do I write the formula to find the total 'small', 'med', etc for those
who deposited over $99. I keep getting an error ...