Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
"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. |
#10
|
|||
|
|||
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula (IF) question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
formula Question | Excel Discussion (Misc queries) | |||
Parsing Data w/ a Formula (another question) | Excel Worksheet Functions | |||
SUM array formula question | Excel Worksheet Functions |