I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.
Example:

quickly see in calander form maturities coming due even in different accounts

I am trying to use the  PV Function to calculate present value of a bond with
a face vaule of $1.5, 20 years, 12% stated rate paid semi annual with an
effective rate of 10.  When I input the data using this function
=PV(5,20,-90000,-1500000) - the value comes out as $18,000 and ...

I am trying to split up a cell into numbers and charachters and place them in
separate columns, but the lenght of the number part varies as does the
content of the character part.
For example, one cell could be 5#, 10Tins, 4 lb, 100Pcs, etc.

I am using the following formula
=INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))
When the caculated value is 0.000 I want it to turn red. How can I do this?

I have three sheets, with the third sheet adding the values from the
first two to provide data of either 0, 1, or 2.  I want to replace all
2's on the summation sheet with zero's, but if I do a 'find & replace'
it won't let me replace by value, only search by equation which, as you

I two worksheets in an Excel workbook. In Worksheet A, column A contains the
company name, while columns B through S contain various ticker symbols of
securities related to the company. The data are lined up such that the
tickers and reference company are in the same row.  In a ...

I'm trying to create a drop-down list (in Data Validation) that is populated
by the subset of a larger list.  The larger list is not sorted, nor can it
be.  If possible, I'd prefer not create a subset list elsewhere in the
worksheet and have a list in Data Validation refer to it. ...

How do I COUNTIF blank cells.  Format of cell is General

Is there a way to do this ?
Thank you in advance.

I have a spreadsheet where we have collected data for the entire year.
Every other row needs to be cleared out.  I need a way to be able to
clear the data from these cells automatically.  Can anyone come up with
a macro for this.

I have a spreadsheet with a dropdown list.  When a particular item is
selected from the dropdown list, a second field is populated. For instance,
the dropdown menu is in cell A1, if a selection is made then B2 is populated.
My issue is the following:  If an item is selected from ...

I have a spreadsheet that I'm keeping track of daily events. Column "A" has a
list
of the diferent events and the columns to the right "b,c,d,e,f,...." are
labled with the

Hi, I need some advice on a worksheet i have.
Here is what it is. Example
Name    Email                        Area
J.Doe   j@hotmail.com              WASH

I'm looking for a function that calculate the total amount of hour
between to time-stemps BUT only the working hours (office-hours 09:0
to 17:00) :confused:
For workings days there is a function "networkdays" but I'm looking fo