I have a matrix where I need to calculate the number of
Unique selections of a single column
An unique selection of a colum is defined as
This colum is the only one who has an X on that row

suppose i hv 3 sheets viz., Sheet1, Sheet2, Sheet3 & i hv data on :
Sheet1 as :
========
COL            A                            B                            C

This is my function...
Function GetNameForSummary(x, y)
    If (Len(x) > 2) Then
        Worksheets(1).Rows(y).Hidden = False

I need to read columns of non-numeric data, and populate another location
(on same sheet, or another one), the frequency of occurance of data, the %
versus total, etc.
For example, one data column could be:

This is a repost that is hopefully clearer about what I'm
 trying to accomplish.
I'm trying to average the last five columns in a row that
have a value. I must always have five(5)values to average

How can I change the number of copies to print.
For example: In cell G22 is the value 11. So I want to print 11 copies, etc.
I supose a macro ... and than ???
Thanks for your support !

When I have the formula =hyperlink(a5,a7), and try to copy it down a list of 100 or so rows, the 'a5' part of the hyperlink (the link itself) stays a5 instead of copying on a relative basis (i.e. a6, a7, a8, etc.)
Does anyone know if it's possible to copy these hyperlinks down so ...

I am trying to create an excel spreadsheet for use by Medicare Beneficiaries. One of the objectives I'd like to accomplish is formulating a way for them to track their deductible (which is $100). Is there a way to format cells to deduct an amount consecutively from this $100 ...

i've got a 3 work sheets containing a month of a year, which is then full of information which i need convert into a single spreadsheet.... each sheet contains the same fields, and may also contain the same data for each month.
the problem is, writing a formula that will only ...

I'm doing a huge (17 page) spreadsheet that is linked to
13 subspreadsheets.  I would like to apply an "isblank"
and "iserr" format to the entire spreadsheet.  How can I
do this?  Info is input onto the subs on a monthly basis,

There was some confusion on what I was trying to accomplish in a
previous post...so I have included a small table as an example.
Date      Profit/Loss      YTD P/L     Start Bal.    End Bal.   Source
1/04          (200)            (200)         10000        9800      

i am having a problem with a spreadsheet i designed.  i
made a macro which inserts a row at the bottom of the
sheet and autofills the corresponding cells with the
corresponding formulas.  my problem is that i have a

I am doing a copy and paste, when I paste my data it
lines up in Column A ; Rows 1 , 2, 3, & 4.  Now I want to
take that same data and have it be in Row 1 ; columns a ,
b, c, & d.  Is there an automated way to do this?

Is there a function that can calculate an inverse
percentage e.g. the formula would be =1/(100%-%figure that
you enter)
e.g. =1/(100%-15%) = 1.1765

Is there a way to return the second value in a range of
values?  I can get the first and last values with max and
min, but I'm also trying to get the second largest.  My
spreadsheet includes multiple rows and columns, so rank