What I want to do is as follows.
In an EXCEL file which I get every month
with a changing number of lines in it, at the
top of the file in any 2 cells, I want to put

I have a very long, array-entered formula which does a couple lookups and
concatenates the results together.  I want to wrap a "RIGHT" function around
the second lookup so that I get just the last character from the text in the
retrieved cell, rather than the entire text string.  ...

How can I expand the excell autofilter range 1000 to 10,000? Also how could I
create a search engine for my excell data base in order to search and fine
what I am looking for in a thousands of datas? If you could sent answer to my
email please! <master7lord@hotmail.com>

I'm tearing my hair out with trying to sort a column full of value
generated by SumIF's.
What I have is a list of about 1000 or so entries which are populate
from a larger list using a SUMIF because there are repeated entrie

I have 5 workooks that correspond to five business deals.  Each deal has a
segment on "Capitalization" of the form
Source     Available capital      Take option      rate     grace     amount
capitalized

cell C1 contains:
=IF(A1>3,1,0)
this obviously does not work, but how to achieve this?
Thanks!

I have file with many sheets, can I create a content of them?

Was wondering if anyone could help.
I have 6 worksheets each containing a table as so
A4 down has dates
B4 down has one set of data "quality"

How to use "sumif" funtion in which there are tow criteria?
A        B
10       1
13       2

I'm new to excel and have to do a project with it and I am stumped as to
how to do this.
I'm trying to set up an IF formula but I can't find the situation.
What I am looking for is, in words, (If B20 increased by 1 over the

Hello People,
I need to find in column A all the items with a 3 in it and add all items in
column B together.
Example:

I would like to have the filename of a excel WB set to
<filename-currentdate> on open the original file so when
the people save it, it will save it to the new name. ie:
open MGA (template file) and make the active WB

Would like to use the IF worksheet function to scan a column to determine if
any of the cells contain a certain entry and if so, to display a message.
Excel Help mentions that this can be done, but does not give any details on
how to do it.

Hi I'm trying to hyperlink using the HYPERLINK() from one cell to
another in different sheets in the same workbook using a cell with a
reference to a row that i want to link to. The workbook's name is
BalanceSheet, the cells are in a sheet called Details, the cell which

does anyone can help me in this issues?
I just read the MS Training but i didn't get it.
Will be better if you can help me with examples and more simple explanations