I have a spreadsheet running while using VLookup, now in the first row I
have multiple dollar values but different account names that relate to the
dollar value is there anyway to return the other account names that have the
same dollar value?

Hi - I have a long list of names (first name and sirname) and I have just
divided this list into 2 columnes. The first column now contains the first
name and I want to delete this first name from the second column (that
contains both names), so that the second column only ...

I am trying to do some lookup, to gett all males stats and female stats, that
are in 10 different group...
EX:
Team 1

Hi,
I am posting this as I have exhausted all avenues trying to get a
result; trying Debra Dalgleish's pivot table tips in the process.
I have a data list which amongst other data items, lists:

How do you calculate an investment that has monthly contributions of, say
$200, every month with a 16% annual rate of return (i.e. $200 on June 1st,
$200 on July 1st, etc.)? This is so that I can get an idea of what the long
term investment will return. I would ideally like to ...

In Excel 2003 SP2 I need the text '1D8+' followed by the value of a different
cell. I tried Cell Formating but it didn't work.

I have a long column of random dates that need to be in order from oldest to
newest. How do I accomplish this in excel?

I want to use function to get the 2nd maxime value of a range. which
function should I use?
Thanks
Viesta

I want to SUM a horizontal row of cells, of which one contains the IF function:
=IF(C2<2,"50",IF(C2=2,"25",IF(C2>3,"0")))
I want the results of the IF function, 50, 25, or 0, to be included in the
SUM.

I want to find the first cell that is not zero "0" across a row. I am also
trying a VBA solution, but is ther percahnce a function that will do this?
Mark

I have a column with a months worth of date/time entries that are in 15
minute increments and I want to create a formula that refers to a range that
is NOT a weekend day and is greater than 9:00 and less than 21:15.  
This will identify a PEAK usage time-frame each day.

Want to advance numbers automaticly for invoice numbers.  Needs to be for
single cell in EXEL.  Need formula. Thanks

I want to create a validation that when i enter a mixed numeric and alpha
reference that i can prevent changing its format.
For example:
Everytime i enter my "number" FEE1234, that the cell keeps the formatting

I would like to ask how to write a formula to summarize info on a separate
worksheet within the current workbook.  
Example: Info is on Sheet 1 in C1 & C2, and Sheet 1 in E1 & E2, and I want
to display on Sheet 2 A1 & A2, and Sheet 2 A4 & A5, with a blank row

I need some help with an Excel Macro.
I have data set that looks as follows:

  1234        6/11           10