I want to craete a league table that automatically list the highest score
first descending along with member name alongside.
Arranging the scores is easy, but I cannot get the names list to re-arrange
to tie in with scores.

Sorting and matching rows of names with Socials with master list and
eliminating the extra names That arent on the master list.  The master
list consists of 739 names and the Names with Social consist of 1263.
I need to match the social with the 739 Names on the master list.

Firstly - I am a big fan of this site, have searched previous questions and
just cant find/understand my problem.
My question - I want to obtain two averages from pivot table data displayed
in cells to the left of pivot table. They are an Average for the entire year

What is wrong about this formula??
=IF(MID(E57,2,1)=1,RIGHT(E57,1),"x")
I have a number 3106 in cell E57. I want the formula to perform the
following:

I'm trying to condense a column (AF4:AF70) into a column that only has
cells with text.  I want this to happen dynamically (with a formula)
Right now there are about 8-14 cells that actually have text in them.
Each cell in the column is a formula that, when it should be blank,

I am trying to write an "if" statement such as
if a column cell equals the number 7 substract the date in one column from a
date in another column
=if(e2=7,h2-f2,0)  - h2 being a date column and f2 being a date column

I'm trying to only include unique values in a data validation drop down list?
the drop down list and source data for the list are on seprate sheets
Thanks for any help

I am trying to update a word document with data i have in excel..i can not
get it to update automatically everytime the excel data changes.  Can anyone
help?

I have an interview analysis tool I've built and need the ability to
have second level analysis for the different questions.  This is
basically on the level of "how many people who answered X also
answered Y?".  Ideally I would be able to do this in three dimensions,

I have a spreadsheet where the data I have downloaded went into two rows,
three columns in row 1 and 3 columns in row 2.  How can I move the data from
row 2 columns A, B, and C to row 1 columns D, E, and F?  I have over 600 of
thse to do, so I wanted to find something automated, ...

I have the below on 2 separate data sheets, indicating if an employee is no
longer here or if a new employee. These are in column H of the data sheets.
=IF($A413>0,IF(ISERROR(MATCH($B413,dataID,0)),"No Longer Here",""),"")
=IF(A514>0,IF(ISERROR(MATCH($B514,PriorDataID,0)),"New ...

How can I subtract a range of numbers from another number?

Our company works around a four week pattern;
Sun  Mon  Tue  Wed  Thu   Fri  Sat
0      7.5   9.5   9.5     7.5   0     0
0      9.5   0      0        7.5   7.5   7.5

I have a list of the 12 months.  At the end of each month information is
entered for the corresponding month.
I have a seperate report that picks up on the YTD information from the input
data.  At the top of this report I show the date ie: Feb-2007, meaning the

I have 10 possible ranges to create a cell value.  I cannot use "IF" beyond 7
and I keep seeing suggestions to use "Lookup", but it's not working.  I need
some examples if they're out there.  Here's what I'm trying to do:
If the cell value in "X" is: <30, then value is 1