Difference between 2 numbers Hi, I'm looking to calculate the differnce between two numbers, Say I have 24 in a columnand next to it in the next column I have 25, I would like it to show the differnce of +1 in the next column. Then say the next row down it has 30 in the first column and 25 in the next it would be a differnce of -5 and so o... 3 Mar 2010 13:02 Calculating 6 days from a date Hi as ever many thanks. I was using it to book course start and end dates BUT to get the actual end date I had to include a sum to minus 1 day:) i.e. course starts 1 mar 2010 for 8 days show end on the 1o mar 2010 but your calculation says 11 mar 2010. Not a problem as sure a reason but many thanks :) ... 3 Mar 2010 10:41 Subtracting data when copied from a IE screen I've copied/pasted numbers from a screen to excel. The data represents hours in xx.yy format. I am trying to subtract 2 cells, but get an error. I determined that the cells have extra spaces so I used clean(). I still get an error when subtracting. I tested the cell with isText(clean()) -- and it indicates... 3 Mar 2010 11:51 Pivot Table showing wrong data I have a table with information such as Salesperson, Customer, Sales \$, Year, Month, Date_Customer_Started. The data contains info for 2009 and 2010. I am trying to determine for every new account created in 2009 and 2010, Sales by new customer and salesperson. The Pivot table has sales data and count of custom... 3 Mar 2010 11:51 Idetnifying repeats in a column Can anyone help? If I have a column of 10 digit numbers, is there a function which can identify when a number is repeated e.g. A B 1 Number Repeat? 2 1234567890 Yes 3 2345678901 No ... 3 Mar 2010 09:33 comparing data I have 3 sets of data. One set drives the other two numbers. How would I compare the other two numbers taking out the affect or leveling the affect of the first driving number. I am thinking a percent change formula? Or would about the analysis tool pak using correlation or covariance? ... 3 Mar 2010 09:33 Index Match Help Data is dumped into Sheet1 and on Sheet2 I need a formula to pull out certain pieces of information. Here is what the data looks like: D.......P..R S 10 B R 3 10 B F 5 10 L R 10 10 L D 9 11 B R 20 11 B F 6 11 S R 20 I want to extract nu... 3 Mar 2010 09:33 Keep cell colour when linking I'm trying to keep the cell colour from the original worksheet when I link the data to another worksheet, the colour is added manually and not conditional. Does anyone know how I can do this? Many thanks ... 3 Mar 2010 19:48 dynamic defined name i have 12 defined names correspond to year monthes (represented in 12 folders) in each folder i have workbook with the same name and structure but sure different data; i want in new workbook (same structure) to sum same cells from different monthes (different difined names) due to user choise; for example : if u... 3 Mar 2010 07:21 Is IF the right way to combine these? Can somebody advise a newbie please? I've got three IF functions that I am trying to combine: =IF(B5>125000,SUM(B5*0.01),) =IF(B5>250000,SUM(B5*0.05),) =IF(B5>500000,SUM(B5*0.08),) I keep hitting syntax errors and when I do combine two arguments the formula doesn't work properly... ... 3 Mar 2010 10:41