I have a spreadsheet which shows names with 2 elements of performance data.  
I want to display the names in a 16 box matrix based on their individual
scores.  
Can anybody help?

I already have my data entered on the spreadsheet.  I need to know a formula
that would give me a percentage of each row or column.  Any help would be
greatly appreciated!
Thanks,

Does anyone mknow how I would reference "Sheet2" to a cell in a worksheet
Need to be able to change the worksheet name based on a cell
Thanks
='C:\Documents and Settings\FP&A\Templates\[SMP2Data.xls]Sheet2'!$A$1

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?
Thank you.

I am trying to get an array formula to sum up a set of terms.
=OFFSET(cll,0,1)+OFFSET(cll,0,2)+OFFSET(cll,0,3) where cll is a Named Range
=SUM(OFFSET(cll,0,{1,2,3})) does not work

How can I count the no. of rows in a sheet depending on the values in  2
columns ?
Eg:
Suppose I have two columns in an excel sheet viz

I am trying to display the minimum temperature for the year by using the
following formula:
=SMALL(E51,H51,K51,N51,Q51,T51,W51,Z51,AC51,AF51,AI51,AL51,COUNTIF($E51,$H$51,$K$51,$N$51,$Q$51,$T$51,$W$51,$Z$51,$AC$51,$AF$51,$AI$51,$AL$51,0)+1)
Can anyone tell me why this formula won't ...

Hi. I created a dropdown list in one workbook (Workbook 1) and the data
source is found in another workbook (Workbook 2). How do I make sure that
even if Workbook 2 is not open, the dropdown lists in Workbook 1 will still
display the items on the list?

I would like to find out why alphanumerics, e.g 14.02F100034 in separate
columns are not detected and hence "#N/A" was displayed. The whole worksheet
was copied and pasted from two separate worksheet and superimposed. I thought
that by formatting cells to GENERAL and pasting ...

Could anyone please help me with MATCH & INDEK function?

is it possible to sort colums when the results of the cells in the column are
dependent on a formula that includes another cell?
Can I somehow "lock" the rows together?

I am trying to take all the orders for different parts from a vendor for a
year and calculate their on-time or late delivery times.
I am having troubles when a vendor delivers early it causes a negative
number.  So I need to do two things 1 find the total early deliveries and the ...

I am trying to count the number of times the number 1 appears in a cell in
the same row for multple columns.  For example, say I have 4 columns, with
the cell being the number 1 or blank.  I need to count every time the number
1 appears in two or more columns in the same row for ...

I have columns that list invoices ,invoice dates, accounts ,subtotals and
totals. When i try to drag the data item into the DROP DATA ITEMS HERE , it
provides a count and not the amounts that i have in the totals field. What am
i doing wrong?

Ok i am back and I am in need of help again
As you all know I have been working on a wage pay spread sheet for working
all around the us
so far you all have helped out bunch