How can I turn a minus result into a zero. For example.... Column A = Stock Levels Needed /50 Column B = Actual Stock Levels /60 Column C =...

Hi, I have a spreadsheet: 1 2 100 5 6 200 5 11 300 I want to find a row which where first column has a specific value and the second column has a specific...

I can't open any of my word and excel files that have IRM protection applied - problem apparently widespread - I believe microsoft are aware of this...

I've seen some posts using Workdays function to find elapsed time from date/time A1 to date/time B1; I'm trying to utilize this, but I have some data that...

Hello. I have datasets exported from map data as large grids (1024x768). I want to transform them into 3 long (768000 rows) columns, with X, Y, and the value...

I have a worksheet and would like to create a form and link the worksheet to it. Then, if I enter information into the worksheet it would also appear in the...

I'm using Windows Vista, and my ribbon will not come up, unless I open Excel in the safe mode each time. This just happened today; I don't what caused the...

When I try to access Excel 2007, I get the following error message from Windows Installer: "Preparing to Install" But nothing installs and Excel 2007, which...

In my old version of office, I could start writing a basic formula and mid-way scroll to another location on the worksheet to select a cell for the formula. ...

Hi, Not sure if I need conditional formatting or a formula for the following: If I put a date into a spreadsheet I'd like it to change colour after a set...

When vlooup found two similar values, it always get the first one. I have the same two values in File 1 but two have two different equivalent values in File...

I have a list of numbers on sheet 1 and need to add a code in the next column. On sheet 2 the first column has the codes, and the next 30 columns have...

How can I make a 34 to a 35 etc etc. How can i round up any number to the nearest five or ten? E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135. thanks.

Sorry, it must be me. This didn't work, things just went straight to Red even though they're not out of date. In the formula =TODAY()-A1=90 should I be...

I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help

Hi, I don't know how come when I filter a column , the column's header ARROW color is not turning to blue!!! Any comment? Thanx

i have a spreadsheet with 5 columns of data that contain address information. Ex. column A = name, column B = Company, column c = Street etc. How do i get...

10-Oct-07 10000 Goog 20-Nov-08 2000 intc 29-Nov-08 4000 intc 21-Nov-09 goog -20000 21-Nov-09 intc -10000 I have the above data. I want to do a xirr for...

Hi All, I have a data which has same item spread over 5 or 6 rows and looks like this Item # T1 T2 T3 T4 T5 1005 Emp...

I need to have a field in a user form to select from a list of options... I guess I use listbox but I do not know how does it works... ho do I populate the...