Using Excel 2000.
Would like to sort approximately 500 row sheet by four columns.
SORT 1: Location column
SORT 2: Vendors used within the Location group

I have read from previous messages that lookups can be done with 2
conditions.  Can they be done with 3 or more eg return a value if 3
conditions are met?
Thanks

Subtotals in Excel 2000 allowed me several levels but the same procedure in
2003 gives me different results.

What I want to do is to consecutively number a list of file names.  These
files are in text boxes in column B. Each text box covers a varying number of
rows.  So files names contain multiple text boxes.  The distinguishing
feature is that the first line of a text box containing a ...

I was wondering is there any way to create a formula that would generat
a picture file.
For example IF(A1>1,flag.gif,"")
I know this doesn't work but I think you might understand what I a

I have prepared a 10 year budget where I ran out of the ability to go beyond
just over 4 years because there are too many characters in the formula. The
worksheet goes like this.  I am opening multiple retail outlets and the main
sheet pulls from a one store model worksheet.  The ...

1st) i download 4 different sets of data from our stores on a nightly basis.  
I insert that days sales data into a template. One store may only have 50
transactions where another may have 200. The template has some preset
formulas in them to calculate margins and costs to the ...

While in a spreadsheet, I started typing a character, but two of every
character showed in the formula line.  When I hit enter, nothing showed up in
the cell.  I tried using a different cell and the same thing happened.

=(IF(OR('Calculation-Part 46 & 48 Viols.'!O17="No
Likelihood",'Calculation-Part 46 & 48
Viols.'!O17="Unlikely"),60,VLOOKUP('Calculation-Part 46 & 48
Viols.'!U29,'Special Assessment

I would like to set up a table in excel that allows me to enter, for example:
A time punched in (8:00 AM), time punched out (12:00 Noon) (for lunch) a time
punched back in (1:00 PM), a time punched out (5:00 PM).
    I would like a final cell to calculate total work hours as 8 ...

I have two worksheets. The first worksheet is called COSTS and contains the
data from which I want to look up values. The second worksheet is called
DETAIL. In the second worksheet I want to obtain a value from a cell in the
DETAIL worksheet, lookup that value in the COSTS ...

I have a "master" workbook that contains customer contacts.  In an effort to
update these contacts I created several columns that contain drop-down list
validation cells.  I'm using cell range titles for my validation drop-down
list options that are contained in it's own sheet ...

how do i sum day of the week without counting sats and sundays?...this is a
function that lotus 123 have the function is for example
@workday(a11,5,fiesta)

"Have you some sheet or add in devoted to perform multivariate
statistics (including discriminant analysis and principal component
analysis) using excel?"

I am trying to set up a sheet to display flexi time with all amployees
working a 7 hour day.  When they work more than 7 hours this is calculated in
numbers and converted to time using the 24 hour clock method.  However when
someone works less than 7 hours the time converison is ...