I am attempting to write an if statement to check values in two columns, and return a value based on the two. column A is difference between two dates (today...

Hi All, I have 2 excel workbook named A and B. In workbook A, I have 4 worksheet 1, 2, 3, 4. In each worksheet (1,2,3,4) under Column B are various part...

Hello, Is it possible to automaticly get a degree symbol in a cel once a type a number? It is possible with currency etc. under format cell and then number...

Hi, I have a vlookup which returns the value from a table called data. The column I want from the table is column 3, so =vlookup(a1,data,3,false) However,...

Dear experts, I've a table with 5 columns. Column B is for Departments and column E is for floor levels. HK1-P L13 QGE ...

I am given 4 amounts that will be deposited into an IRA and will earn x amount of interest and th uestion is how much will they have after 4 yrs. I know that...

I require a formula that if cell A2 has the cost of buying clothes. Cell B2 has the cost when selling clothes. If the cost of A2 (selling the clothes) is ...

In the most updated version of Excel there is a way of taking a pivot table and producing multiple worksheet reports in order to send them to...

How can I convert 5456 into text. Thanks.

Is there any way to write a formula the puts the result as text in the cell just to the left of the cell the formula is...

address'Still trying to solve a problem with showing cell address'. I can determine if the "name" if there, and how many occurences there are (Thanks...

With vlookup, and a range lookup value of TRUE, when there is no exact match, is it possible to return the smallest value that is greater than the lookup...

Some contacts were emailed to me. When I down loaded them and attempted to save them, they went into an excell file. I did however save them in a...

I have the below table where Weightage is nuber of bookings a person can action in one hour. '17' is the total that has been actioned in 8 hours. I need to...

Here's an example of a spread sheet: A B 1 1 $55.25 2 $997.00 3 $693.36 4 1 $535.00 5 ...

Should be a simple fix. I am summing numbers in a column. When I enter new data in the column, the sum doesn't re-calculate automatically. If I re-type the...

lost left, center, right function. how do I restore the tool?

I would like to enter a date (not today's date) on Worksheet 1 and then update it automatically on Worksheet 2. Worksheet 1: January 1, 2009 Worksheet...

I have a workbook that contains 1 tab for each day of the month and a status tab that I want some of the info on the individual tabs to roll up to. On the...

Here is my Data: A B C D E F GRADE Teacher LN FN MN DOB KK Cain FlintstoneFred Bam-Bam02/22/04 I need to concatenate LN, 1st letter of FN, 1st letter of MN,...