formula question
 

If I have numbers in col a and col b and I have a formula in col c that is
a1-b1, then in c2, I have the same formula + what is added in c1, and the
same all the way down, (keeping a running total). Question, is there a way
to have in col c an automatically way to have the formula without me having
to drag or copy down, so when I type in the numbers in a and b it will run
the formula and keep the running total from the cell above.

I am not sure I understand you but you might want to check "extend list
formats and formulas" under toolsoptionsedit

--

Regards,

Peo Sjoblom

"Pam Coleman" wrote in message
...
If I have numbers in col a and col b and I have a formula in col c that is
a1-b1, then in c2, I have the same formula + what is added in c1, and the
same all the way down, (keeping a running total). Question, is there a
way
to have in col c an automatically way to have the formula without me
having
to drag or copy down, so when I type in the numbers in a and b it will run
the formula and keep the running total from the cell above.

starting in row 2 you could try:

C2 =A2-B2+C1

"Peo Sjoblom" wrote:

I am not sure I understand you but you might want to check "extend list
formats and formulas" under toolsoptionsedit

--

Regards,

Peo Sjoblom

"Pam Coleman" wrote in message
...
If I have numbers in col a and col b and I have a formula in col c that is
a1-b1, then in c2, I have the same formula + what is added in c1, and the
same all the way down, (keeping a running total). Question, is there a
way
to have in col c an automatically way to have the formula without me
having
to drag or copy down, so when I type in the numbers in a and b it will run
the formula and keep the running total from the cell above.

How about Find & Replace?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ian" wrote in message
...
Is it possible to clear the contents of a cell if if contains a certain
text strings, i.e. I want to clear all cells in a particular column that
contain the phrases "son of", "dau of" and "wife of".

Thanks in advance.

Well, no. It will work.

Find: *son of*
Replace: <blank

In article ,
Ian wrote:

No, that won't work because it will only replace part of the cell
contents, i.e. "son of William" would become "William" rather than
blank.

On Sat, 09 Apr 2005 14:07:18 GMT, Ian wrote:

Is it possible to clear the contents of a cell if if contains a certain
text strings, i.e. I want to clear all cells in a particular column that
contain the phrases "son of", "dau of" and "wife of".

Thanks in advance.

You could use a VBA macro:

=========================
Sub ClearSpecial()
Dim i As Long, Count As Long
Dim c As Range
Dim Phrases As Variant

Phrases = Array("son of", "dau of", "wife of")

For Each c In Selection
For i = 0 To UBound(Phrases)
If InStr(c.Text, Phrases(i)) 0 Then
c.Clear
Count = Count + 1
End If
Next i
Next c

MsgBox (Str(Count) & " cells cleared")

End Sub
============================

To enter the macro, <alt-F11 opens the VB Editor.
Ensure your project is highlighted in the project explorer window, then
Insert/Module and paste the above code into the window that opens.

To use the macro, select the range containing the cells you wish to
conditionally clear. Then <alt-F8 opens the Macro Dialog box. Select your
macro and run it.

Many variations are possible depending on your precise requirements.


--ron

Highlight the column, then Edit Replace Find what" son of* Replace with:
leave empty Replace all

Vaya con Dios,
Chuck, CABGx3


"Ian" wrote in message
...
On Sat, 9 Apr 2005 11:40:54 -0300, "Bernard Liengme"
wrote:

How about Find & Replace?

No, that won't work because it will only replace part of the cell
contents, i.e. "son of William" would become "William" rather than
blank.

You're *not* searching for
son of

You're searching for
*son of*

NOTE, John instructed you to include the wildcard "*".
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Ian" wrote in message
...
On Sat, 09 Apr 2005 09:20:49 -0600, JE McGimpsey
wrote:

Well, no. It will work.

Find: *son of*
Replace: <blank


I'm probably missing the point here but how will the Find/Replace
function clear the whole contents of the cell when I'm only searching
for a part of the whole string, ie how will searching for "son of"
replace "son of William" or "son of Henry James" etc ?






In article ,
Ian wrote:

No, that won't work because it will only replace part of the cell
contents, i.e. "son of William" would become "William" rather than
blank.

"JE McGimpsey" wrote...
Well, no. It will work.

Find: *son of*
Replace: <blank
....

Quibble: This would also clear out cells containing, e.g.,

Perry Mason often won his cases.

Substrings as part of longer words are a pain. Microsoft is a pain for not
making the enhanced wildcards available in Word available to Excel as well.

"CLR" wrote...
Highlight the column, then Edit Replace Find what" son of* Replace
with:
leave empty Replace all
....

If only there were spaces at the beginning. If not, major PITA.