I have spreadsheet that contains the following info:  column G contains # of
employees and column K contains revenue, basically I want to see how many
accts have less than $1000 in revenue and between 1 and 9 employees
I used the following but it didn't work:

Is there a worksheet function that can return the date the file was last
saved?
I know it can be done by using macros, but I don't want my users to get all
the warnings etc. Is there a way to get that date without macros?

If I have a workbook with 15 sheets, it would be nice to be able to sort them
by title or search for a specific sheet.  Is there a way of doing this
without phyically looking at each tab?  Thank you!!

In a solution posted by Biff on Oct 24, 3:18AM, subjected "Vlookup formula
criteria" in a reply to gmunro question, Biff used an IF function with
following structure:
=IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1)

Using Excel 2003
I have a cell (B3) that has a value of >0.30%.  Then I have another cell
(B5) that has a value of 0.35%.  I want to know the difference between the
two values, which is 0.05%.  I cannot just use the formula =B5-B3 because of

I am transferring data from an AS400 into Excel.  The date field comes into
Excel like this: 60501.  This date is actually 05-01-06.  Just like Excel,
the AS400 suppresses the leading 0 in the date.  We cannot get the date data
to come into Excel any differently.  I need to ...

I have recorded which protects worksheets and the workbook with passwords.
The macro is stored in the Personal workbook. When I run the macro against
another workbook it runs ok but the passwords aren't embedded.
What have or done wrong or is this not possible. Looking at the the ...

I often use filters to create various reports in analysis from larger
querytables, but it's quite timeconsuming to change headers, titles and such,
to secure the right understanding of the content of a printed report. Having
an option to define this in the Header/Footer section ...

I am using: Hyperlink("[workbookname]worksheet!cell","genericname") and when
i click on the cell instead of jumping to the location in the active workbook
it tells me that it "Cannot Open Specified File"....it's not supposed to open
a file, it's supposed to take me to the ...

I have two columns (Start date) (End Date).  I am trying to create a formula
that counts by Year then Places the by month
Start Date    End Date
10/23/06    11/04/06

Given the following dummy data (my real data involves hundreds of rows,
hundreds of color columns, and multiple "rank" columns):
    A    B    C    D    E    F    G    H
1        Rank    Colors    red    yellow    blue    green    orange

I am trying to assign numerical values to grade scores - b+, c- etc, however
when i use lookup like this
=LOOKUP(C5,{"U","G-","G","G+","F-","F","F+","E-","E","E+","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+","A*"},{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21 ...

I want to have a hyperlink pointing to a different cell depending on the
value of another cell.
i.e.
Cell A1 has a variable value depending on some function, e.g. Z8 (which is

i used the following VBA code to chage the colour of using a condition -
Sub test()
If Sheets("Sheet1").Range("A1").Value <> "hello" Then
Sheets("Sheet1").Tab.ColorIndex = 6

The symbols { and } appear at the start and end of a formula but disappear
when entering edit mode on the cell. Also the formula cannot be changed as
pressing enter from the edit mode causes the formula to produce a #VALUE!
error.