Hello from Steved
Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark James"
Ok can I get the formula to combine the both to get = "ADDISON Mark James"

I have a list of ages in one column, adjacent to it, is the 'fractional' part
of the age:
AGE     INT    AGE-INT
54.32    54    0.32

I have a list of team names and scores, how can I use an array formula to
sort the scores descending by team name?
I have heard this is doable but am struggling so far
Any help much appreciated

When one copies and pastes content from the web, all unusable graphic get
copied over to Excel and it requires to click each one (which may have
overlap or be invisible) to delete one by one.  A find and replace all
function for graphics (like Word) would solve this problem.

Column "P" contains a list of values that may appear more than once. I would
like to have only ONE instance of each value returned from Column "P" (Rows 2:
40) to Column "E" (Rows 50:88) in ascending order without blank Rows from
where the duplicates would have been.

In Excel, if I have a column of numbers, how do I tell Excell to find the
last number in that column?
Thanks
Shyam

Hi, I have a spreadsheet that has every day of the year (1/1/2004 to
12/31/2004) and I am trying to sum a column next to it to get only
totals for each month.  Basically I want to know what I get as a sum
for all of January, February, etc.

Hello from Steved
=IF(ISNA(VLOOKUP(E6,$T$2:$Y$2000,6,0)),"",VLOOKUP(E6,$T$2:$Y$2000,6,0))
=U2&CHAR(10)&V2
ok =U2&CHAR(10)&V2 combines the 2 values into 1 (surname and first names)

I have a spreadsheet that has 4 columns in my results page.  These columns
contain dates.  For instance I have a Committed Cure date and an Actual Cure
date and then a committed test date and an actual test date.  
There are a number of rows and several sections that need to be ...

Need Formula for calulating age from birthdate from current date.  I have used
=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
of  2005.  I need formula to calulate age as of today's date or by current
month.  I want to show the age in the cell next to ...

I am using a formula to randomly select one of the values in a list.
However, the value returned by the formula changes with each
recalculation (F9), and I do not want that to happen.
IS THERE A WAY TO GENERATE A RANDOM VALUE FROM A LIST WITHOUT IT

I am working on a spreadsheet that will be used to calculate financial
ratios. I have 2 worksheets; one is named data and contains the company name,
year, and the values for certain financial information. An example of the
data worksheet looks like this:

I am using Excel 2003.  Is there a way to set all comments to a default font
size?
Thanks,
Liz

I have 4 columns
A=cardholder
B=trans$
C=monthly limit

Hello, I am looking for a the proper function in excel that would allow me to
count if a criteria is matched in column "A" and if another criteria is
matched in column "B".