If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Array Formula Question - Urgent, please | Sandi Rush | General Discussion | 2 | September 18th, 2004 06:16 PM |
Question about Absolute reference formula | Maria | General Discussion | 3 | June 23rd, 2004 06:27 PM |
Challenging Question - Troubleshooting Formula | Rachel | Worksheet Functions | 7 | May 12th, 2004 04:42 PM |