I want to know the combinations of four letter that are possible from a list
( abcdefghij ) .
The =combin function will tell me how many combinations are possible.
=combin(10,4)

Hi there everyone
I would like to know if it is possible to show just a few columns in an
advancedfilter.  For example, I have a worksheet of 10 columns which I
hope to show just 3 of them after advancedfilter.  Is it possible, how

I have a row of cells that calculate the totals for their columns but I
force to be blank via IF statements until certain conditions are met.
Once these conditions are met, the total appears.  I'd like to also
highlight these total cells via conditional formatting.  My conditional

Help please .....
I have been given the task of keeping the accounts [on excel] in order. The
business has the sales client name and figures listed per month on different
worksheets.

I see that Excel 2002 & later allow you to change the startup settings
for updating external links so that you will not be asked and the links
will not be updated automatically.  Is there a way to do this in Excel
2000?

I can do the following with a macro, but is there any way to do it with
a formula?
On Sheet1, column A contains six digit numbers, like 123456, 314258,
and so on.

I want to know the combinations of four letter that are possible from a list
( abcdefghij ) .
The =combin function will tell me how many combinations are possible.
=combin(10,4)

what does this represent? }

Hi every body,
I am a new member of this group.
I prepare programms in excel with the help of various functions.
Can any body tell me any way that any person not able to run the excel

I have a number of rows on an Excel worksheet. I'm writing a macro to loop
through each row and process the info on that row. The number of rows can be
variable.
How do I determine how many rows are in use? When I type CTRL-END, the sheet

have a spreadsheet with several columns -- some data, some dates.
Does anyone know how I can create a formula to do the equivalent of
filtering on three
different columns with a different date for each column filtered?  For

I recently got a new computer running Windows XP Home Edition.  I installed
my Office 97.  Now when I open up any Excel spreadsheet I get a message
saying "A document with the name 'xxxxxxx.xls' is already open.  You cannot
open two documents with the same name, even if the ...

My columns are Completed Review, Hours Invested, Avg Time Per Review.
With 36 reviews completed and 65 hours invested, I divide to get
1.805556.
I know that the answer equates to about one hour and forty-eight

I have a problem, which I cannot seem to sort out.:confused:  I have
two spreadsheets. The first spreadsheet, column C is a list of cities,
and columns H through AC is a list of dates under which employee names
are assigned.  The employee does not always work in the same city and I

I am having trouble getting this formula to work, can anyone help m
out?
This is what I have:
=IF(Z4:AC4,AH4:AJ4={FAIL},"YES","NO")