Functions

excel crashes when changing web query
Hi, In excel 2003, i have a file that pulls in data via Data / Import External Data / New Web Query. I've been using the file for about 3 years, and now when I try to edit the query to pull in the latest table on the same website, excel crashes. And it does the same on another pc running excel 2003. However,... 8 Apr 2010 00:44

how do I change number format from 3,999.89 to 399989
... 8 Apr 2010 00:44

How do I count # of cells with same value other column?
In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A. For example: A B 1 yes yes 2 no no 3 na na 4 yes ... 8 Apr 2010 07:16

Formula to Return age
see http://www.cpearson.com/excel/datetimews.htm scroll down just a few lines and he has a formula for determining age in years, months and days. "Mark" wrote: Hi, Trying to get an age cell to self populate based on a cell containing persons date of birth. As always thanks for your help. -- Mar... 7 Apr 2010 21:26

copy data from one sheet to another using a combo box
I Have 2 sheets, a database of items sheet and a form with a combo box to put the record I get from the database. I want to pick a record from the database sheet and add it to my form and have it bring the whole record with it to the form.both sheets have the same fields. -- Thank you ... 9 Apr 2010 10:02

How do I write this logical argument?
What's the way to write in Excel "if cell A1 has a numeric value" or "if a cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that begins with that condition, and goes on to have a string of other embedded functions. Thanks in advance. ... 8 Apr 2010 19:43

Comparing Two Sheets
I am trying to do something similar - but want to fill to the last row without manually changing the range for the last row. any hints? "Rob van Gelder" wrote: Assumptions: Sheet2 contains all of the customers Sheet1 contains no more than 1000 customers A1: =Sheet2!A1 B1: =VLOOKUP(A1, Sheet1!... 7 Apr 2010 18:03

Formatting does not follow when copying from one cell to another
I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? ... 7 Apr 2010 19:11

Changing coler of tracking cells
When I use "track changes" the changed cells are outlined in lavender which is really hard to see. Is there a way to change the highlight color to a darker one? ... 7 Apr 2010 15:47

conditional formatting?
I have a sheet that has a formula that calculates the dates of cleanings, i have made a conditional format so that the dates that are coming up and past month are highlighted. I now want to be able to change the conditional format back to normal or another colour when the job is done, is there a way to do it? Subm... 7 Apr 2010 16:54