I'm trying to rank user's cell minutes of use based on what account they fall
under, and if they are on a particular plan.  Here is an example of the
information.
cell #           MOU           plan                                Acc#

When I use XIRR, how do I make the Date format work? I tried changing the
cell format to Date, used the DATE format option, but still Excel sees the
date as a number not date format.

How can I get the XIRR function to work for a positive number in the first
value cell? The XIRR works when you cut and paste the HELP example on
Microsoft's home page but not when you input real values. I already completed
the Add-in step.

Is it possible to hide a row based upon a value one of the columns?
Thank you.
Jeff R.

I am trying to use a Drop Down list for data validation and do not want a
blank cell to be accepted.  I have unchecked to Ignore Blank Box, but there
is no warning message.  I have typed the list at the botton of my worksheet
and used the cell range as the Source.  There are no ...

Trying to figure out how to do this. Lets say I have a large excel
workbook...maybe 20 pages.....100 rows in each.
I want to look up a name in column B....and return all of this name
along with the data in an adjoining column. Hope this makes sense.

I want to set up a formula in a cell in one worksheet to display the value of
a cell that is the intersect point of known values in two other cells in
another worksheet (same workbook).  E.g., I know the text values of A10
("SF") and E1 ("LA") in Sheet1, so I want the formula in ...

vlookup looks for the lookup value in the left most column of the table
array. Is it possible for it to look for the value in the right most column
of the table and return a value from a column to the left?
This is backwards from the vlookup statement - I realize. I can't tranpose ...

I have 2 lists of clients, which may contain common clients, but the company
names may be written differently, such as Baptist Health System and Baptist
Medical Center.  List A is the standard list that I wish to tie my records in
List B to.  List A contains 6,000 records and B ...

Im trying to create a formula that will sum the values of one colu
based on the values of two other colums
Colum A is Date
Colum C is Name

Is there a way to make excel stop calculating a formula when it is taking an
excessive amount of time?  i.e. when running certain pivot tables, if the
data is not sorted properly it will take several minutes to run a summary.  I
would like to be able to stop the calculation, sort ...

Hello from Steved
I would like a formula to calculate the time it takes to travel 10
kilometres driving at 28 kilometres per hour.
Thankyou.

I have a spreadsheet filled with thousands of different inventory
items.  Each column represents a characteristic, size, type, product
code.  Each row is a different item.  
One of our columns is the product code of the same item, only in our

I have filters on several columns in a spreadsheet (Excel 2002).  I know I
can do File-Send To-Mail Recipient and email a "picture" of the filtered data
to someone.  However, if I use File-Send To-Mail Recipient (as Attachment),
the recipient can remove the filters and view all ...

In Excel 2000 -- I would like to create a summary spreadsheet (sheet2).
For each time that "Name" appears in sheet 1, row *, take information from
the same row, but columns 2 and 6 and bring it over to sheet 2 in the
designated area.