I have 2 sheets: Data and Terminated Employees, respectively.
IN DATA SHEET:
_Column_A_-----------------------------------------_Column_E_
A1:Employees (heading)---------------------------E1:DOT (date of

I have used the following formula:
=VLOOKUP(A2,'[data aug15.xls]July 2005'!$A$2:$C$9216,2,TRUE)
I get N/A errors throughout the entire column.
Does anyone have any clue what I might be doing wrong?

This is what I am trying to do I am keeping track of my bank account using
excel. I have it set up to were I enter a category in one column and I have
columns set up for credit and debit and amount. If the item is a credit I
place an "x" in the credit column and if its a debit I ...

Let us say I have a list of over 4000 case numbers in column A. In the other
columns I also have case numbers but much less than in the column A, an
average of 700 and a maximum of 2000. The idea is to sort the cell values
according to the values in the first column.

Hi I'm using Excel to keep an attendance sheet. I need to collate the days
that people are in the office, working at home, or out of the office on
business, into one figure.
The data is stored in B2 - BF (eg).

Does anyone know - I have an IF statement setup asking if a formula >0, same
formula +.01, same formula. (the formula figures an hourly rate based on a
set gross amount taking into account reg and overtime hourly rates and
returns an hourly rate based on a predetermined gross $ ...

i am trying to copy a range of values in a csv file into a new sheet in order
to import it into a stock control module, formulas in original spreadsheet
are being copied and altering values.

I need help I have a spreadsheet that has the following information,
Total Hours
SPH
SALES

I have saved my worksheet over the correct one, is there any way I can get
the old one back?

how do I do a SUM or similar but ignore the two highest and two lowest values?
there are 36 values in a column.
Thanks

I want the cell to count, but only if 2 separate arguments are met.  Can that
be done?

How do you move from any cell in Sheet 1 to any cell in other Sheets in the
same worksheet.
With Sheet 1 being a index of names, by selecting a name to take you to the
info.

Hope someone can help: I’ve searched but can’t find a similar questio
so apologies in advance for repetition. This seems REALLY simple bu
I’m failing miserably!
Basically I’m designing a spreadsheet to track the performance of

I want excel to sum the highest 5 numbers in a row of 20-25. This means
it'll first need to find 5 highest values and then add 'm up.
Example:
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20

This one has me stumped.
I have a range of 40 cells. All cells have the default of 999 in them
When some of them have been populated I want to find the LARGEST of those
new numbers.