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

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...

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 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 ...

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...

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 have an Excel File that I am trying to pull data from. I'm dealing with Time, and Temperature. example: A B Time: ...

I would like to create an data input form for cash payments journals that will be accessable by everyone in the company, and then have the information in the...

I got a new computer and am missing a function I loved on my old one. In Excel, I could highlite a group of numbers with my mouse and the sum of those numbers...

A vlookup is simple in it's capabilities, but I want to get clever. I'm looking up a value from another workbook. Simple enough in itself, but heres the...

My IF function is not working when I populate the appropriate cell with speech recognition. Is this a limitation with speech recognition? Is there...

I want to make a worksheet function that will search for an empty cell and then stick a character in it. "IF" only seems to work with a cell's contents, not...

I am currently working on a template for a coworker that allows them to quickly see which products need to be ordered now, soon, or not in the forseeable...

I am working in Excel 2003. I have a table of data that has been extracted from a database. It details peoples name / month / basic pay / grade / hours over a...

Hello Why does IF(logical_test,a1:z1,value_if_false) in one cell use a value in sell z1 and in another cell use a value in cell a1?

If in Sheet1 A2 is a negative number put in A2 in Sheet2. If in Sheet1 A2 is a positive number put in A3 in Sheet2. How can I do this with a formula???

Hi, I would like to find out, does Find (Ctrl + F) works in protected file with formulas? As one of my user tried to use Ctrl + F in her protected file (with...

Hi guys, Assume the table below in cols A to C. I'm looking for a formula which can be placed in the Adj_Prize (col C) to compute the adjusted prizes...

I need to move only the color of a cell into another cell.

Hey I'm looking for a way to sum rows but ignore the adjacent rows which are hidden. excel is adding the stuff in the unhide rows (which is what i want) but...