I need a better formula.
I have two lists (that change frequently) one is up to 50 items long, and
the other is up to 5000 items long. Both are in columns. Many of the items on
the 5000-item list are on the 50-item list, but not all of them. I need to

I have to add to the following formula:
=IF(OR(C12={"None";""}),"",VLOOKUP(A12&"-"&F12&"-"&G12,INDIRECT(CHOOSE(MATCH(C12,{"Internal";"External"},0),"'Writing
Charges'!D3:E60","'Writing Charges'!G3:H60")),2,0)*I12)
the next part needs to be

How do I remove a 'Comment' indicator from a cell in an Excel sheet. The
indicator is the red triangle at the top right-hand corner, placed there
after clicking 'Edit', then 'Comment', when the cell is selected.

I would like to specify which columns I need to print in a macro.
I would like it to only print columns A-C, E and K
Is there a way to do this?

Greetings - why does Excel automatically interpret 1:53:822 (1 min 53.822
secs) as 0.087986111, yet 1:53:022 is not changed at all?  Is there a way I
can calculate backwards the 0.0879... result into the original 1:53:822?
(These are times I am copying/pasting from a website into ...

This is going to be difficult to explain  - but I will do my best.
I have several co-workers that have had this happen.  It doesn't matter what
version they are using - some have Office XP, 2003 and now 2007.
What happens is that you are in a paticular cell, it can be blank or have ...

I have change the setting of digt group under Number & Curency tab in
regional setting in control panel from 123,456,789.00 to 12,34,56,789.00. But
still I could not able to use the update changes setting in digit group. How
can I use my update digit group setting.

Just when you think you understand something.....
I am trying to create a formula that will make a cell on one worksheet equal
to a cell on another worksheet (worksheet is determined by a list of
worksheets).

Is there a way to have Spell Check run when you close the workbook, similar
to having it run when you click send on an email?
Thanks.

I can round a number up to the next digit, the next ten or the next 100 or
the next 1000 ... but not to the next 500 .... in a spreadsheet in use for
estimating quotes for heating installations - anyone any ideas?
(Practical application is:- clips for holding underfloor heating ...

I'm using this to add mulitple work sheets
     Set ws = Worksheets.Add
     ws.Name = sheetName  ' error line
I am pulling sheetName from another worksheet and am getting an error when

I would like to set a keyboard shortcut (e.g., CTRL+M) to paste special

I used data - validation in excel to create an input message when selecting a
cell for data entry.  How do I get the message to be close to the cell I
click instead of the message appearing on another part of the worksheet away
from the cell?

For example I have 39:83.  I want to convert to 39:49
I want to only convert the :83 decimal into minutes.
I am using the =text(value/24, "h:mm") but this is converting 39:83 to 13.49.
Please can anyone help ?

I have a column with dates and another with quantities. I need a sum of the
quantity of only applicable for last 7 days from today.
Dates    Quantities
11/12/2007    3