Results 1 to 4 of 4

Thread: Delete data without deleting the formula

  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0

    Delete data without deleting the formula

    I want to delete the data of this column without deleting the formula is this possible?
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    10
    Rep Power
    0
    The data is the result of the formula, so no, you can't
    Clear the values in Columns B and C and use this Formula.
    PHP Code:
    =IF(OR(B3="",C3=""),"",SUM(B3:C3)) 
    Last edited by bakerman; 12-10-2013 at 08:24 AM. Reason: Tags added

  3. #3
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    You can hide the entire column or change the cell's text colour to White but, as said, you can't clear the result of the formula unless you clear column B and C.
    Last edited by rollis13; 12-09-2013 at 02:52 AM.

  4. #4
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Thanks to all

Similar Threads

  1. DELETE PAST FORMULA IN EMPTY CELLS
    By Zayn_21 in forum Excel Help
    Replies: 1
    Last Post: 08-15-2013, 05:39 PM
  2. VBA Confirm Message Before Deleting Row
    By mackypogi in forum Excel Help
    Replies: 14
    Last Post: 08-12-2013, 11:23 AM
  3. Deleting a Row with a specific data shown.
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 07-18-2013, 03:41 PM
  4. Deleting Records Using Join
    By MMishra in forum MS-Access Tips And Tricks
    Replies: 0
    Last Post: 04-24-2013, 04:06 PM
  5. Deleting blank rows
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-14-2011, 03:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •