I have an Excel File that I am trying to pull data from. I'm dealing with Time, and Temperature. example: A B Time: ...

Hi, I would like to be able to AutoFilter on two non-adjacent columns in a spreadsheet. Is there any method to perform this task in Excel 2002 (XP)? I get an...

I am adding records and want a warning to appear if there are duplicate values in 3 columns - Project; Name; Phase If all three are duplicated then warning...

I am trying to pull employee ids from once excel sheet to another. The only problem is that the names appear in two columns in both sheets. first last ...

In cell a1 I have a number that represents hours worked by an employee. I need a formula that converts that number into years, months and days.All I can do is...

I'm trying to concatenate two columns in a spreadsheet that contain date information. I want the data concatenated into a new column with the dates separated...

i am using the following formula to populate certain...

I will try to make this as short as possible! Here is the situation. I need to count "incidences" based on particular criteria in a spreadsheet that contains...

Everytime I cut and move a workbook to a folder, excel automatically generates another copy of that workbook. It is creating multiple copies, of which i do...

Hello and thanks for the help, On sheet one I have the following: A B C ...

I am using the transpose function to send arrays of colored cells with data from one worksheet to another in the opposite orientation. The data is transposing...

I have entered numerous items in my auto correct file. How do I go about sharing this file - say copying to a disk - and placing on other computers? Thanks...

Is there a way of writing an IF function to test the values in 3 cells and return a message depending on which cell has the highest value? For example if A1 =...

Is there are formula in excel that will check a file for duplicate entries. I have a huge list that I know contain duplicate addresses. I seem to recall that...

How do I calculate a formula for the amount and profit of each sale in each row? Like, the amount is $109,692.00 and the profit is $3,713.00. How do I get the...

I am working with excel and dealing with multiple spreadsheets. I am configuring data for By Company Total, then into By Rep Total and now into By Region...

I have an excel worksheet with cells that are linked to a different tab in the worksheet. The cells are correct... but the number is not. I cannot tie the...

If A1 is blank, A2 is january, B1:AF1 are days of the month, B2:AF2 are dates(1st-2nd etc) how do i get them to change for the whole month by just changing the...

Hello How to make LOOKUP give zero if it can't find the lookup_value?

I can not get this to give me a value other then 0 {=SUM(IF('reference data'!$E$2:$E$125,"=1",IF('reference data'!$I$2:$I$125, "=1",'reference...