Hay everyone!
I have one problem in Excel and I'll try to explain it. It is comple
table (with formulas, etc.) but I have problem with one column. In thi
column are "Products" - all kinds, but I have to make sort withi

I have a worksheet with 8 columns and 600+ rows of data. I have filters
enabled for all the columns. Column "A" is for last names. When I filter the
names in column "A", I will get about 10-20 last names. I would like to have
formula in cell A-10 that will use the last name that ...

I am an old Lotus 123 user.  Help, I need a IF THEN DO to work for me on a
spread sheet, any info.

I am fairly new at Excel and Access doing formulas and I
have a problem which after an hour I am stuck and Help doesn't give
enough information for me to work through this.
I have created an Excel document for scoring tournements. The entire book is

I have a VLOOKUP function in my excel worksheet. I built it using the
wizard.  When I look at the function argument wizard, the function result
value at the bottom is correct. However, in my cell it simply returns the
function equation and not the value. I even hit F9 and nothing ...

How do I write a formula to determine a % of "yes" responses for a range of
cells. For example: Cells C2-C20, 12 of the 18 cells have "yes" the other 6
have "no". Cell C21 would have the % of yes. Thanks!!

I want to plot trendlines in a xy-chart, not just one. How can I plot
trendlines(linear) in the chart with different steps? Ex for x: 0-100,
100-200...I need the equation of the line of best fit for the different steps.
oks

I trying to write a formula where if I input any letter into a cell I want
the adjacent cell to display the alphebtic number of that letter.
Where A=1 B=2 etc etc Z=26
Example.

the formula =networkdays(a1,a2) worked in office 2000. After i upgraded to
office 2003 it does not work. I get #name? error. I cannot find the function
in the function list, but it is still in the help and online help says that
the formula is correct. What happened?

i have been attempting to forecast a balance sheet & P&L account for the
following year which i have managed to do, but am unable to work out the best
and worse possible outcomes and was wondering if anyone knew how to do this?
thanks

ok so i have a problem, i cant seem to answer it, im not sure if you should
use frequencey or countif!
I have a list of ages from 20 -79, and i need to find out how many times
theres a  occurence for each age group ie

I want to round of near to zero. i.e.
If there is a qty * Rate = amt
456*89=40584 than i want to round of like  40580 i want to make last digit
0(zero)

I have a document in word that we use as a template but, there is information
that we need to input into it on a daily basis - we are currently using
find/replace. It is a long document - does anyone if I can make a program
that has macros in it in Excel which will replace text ...

Need a formula to evaulate (If CellA = 1, Then enter value in CellD), OR (If
CellA = 2, Then enter value in CellE), OR (If CellA = 3, Then enter value in
CellF).  Any/all assistance is greatly appreciated!

I have two similar worksheets that I am trying to consolidate based on the
column that represents the date.  I just don't know how to use the feature or
how to fomat the formulas.  Also,where do you indicate where to put the
resulting consolidated data?