How do I use the SMALL command when I want it to look at values liste
on different sheets? The problem is that it won't let me list more tha
one array like the minimum command allows me. Or is there some way t
list cell numbers inside a bracketed array instead of values? Fo

Is there a function to count blanks in a filtered column?  That is, i
I filter a column to show the rows that are blank, can I use th
subtotal function (or some other) to count the number of blanks?
Thanks,

I have a worksheet that is Plan calculator for customer of a teleco
company. There are four sheets,
sheet 1 Instructions (Instructions given how to put data and ge
result)

I'm trying to create an amortization table in Excel for a
Canadian Mortgage but I can't find the right formula. PMT
does not work in Canada since interest is calculated on
the balance every 6 months but the payments are made

is there a way to format a cell such as:  enter 2378 -- two thousand three
hundred seventy-eight appears

how do i get a yellow text box to pop up with directions when i'm in a cell.  
i know about the comments box with the red flag in the corner of the cell but
i just want it to popup when i am in the cell

Hello - let me preface this post by stating that I am a novice in
regards to Macro programming. That being stated, here's my issue.
Every month, we receive hundreds of Excel files from various business
units. The filenames are always different and they change

In Excel, workbook have a tab that displays the name of its worsheets.  Excel
gives you the ability to customize the name of each worksheet by editing the
name of the tab.
What I would like to be able to do, is to have the ability to link the name

I need some help! I have a workbook which has four sheets, the two that
matter are named work in progress and receipt. My problem is that I need to
copy the name, address, city, state, and zip code from the in progress sheet
to the receipt sheet, one at a time and place them in ...

I have a large workbook I am manipulating.  I would like to change the needed
price in the worksheet named 'summary page' and it would update to all the
needed worksheets within the same workbook

I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A
to IV.  Obviously I have run out of columns and will switch to rows.  How do
I import row 1 to col A and row 2 to col B?

I'm having a real difficult time with this andi 'm sure it's no proble
for you experts.
I'm trying to find a match in columns A,B,C,D,E, or F and have th
function return what's in column A in each instance. But the matc

I want to be able to display up and down arrows pertaining to price movements
in a spreadsheet?

I just need a refresher on how the IF function works with 3 variables.
This is for calculating bonuses based on how many years of seniority an
employee has.  Example is:
1-5 years     $4000 bonus

I have create data using several worksheets. Each one link with password
(macro). I uncheck sheet tabs (thur option command). User have to enter
password to preview or access to the worksheet. But user still can access to
worksheet after they check sheet tabs using option command ...