• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Compare previous and current value of a cell

    I have a table which requires that several cells' values need to be manually updated. This causes a cascade of calculations to be triggered and results are displayed. As each of the manually-updated cell values are entered, I would like to display (by any means) the difference between the old...
  2. S

    How to prevent a TODAY() function from updating every time the sheet is opened

    I have an inventory-type spreadsheet that inserts TODAY() in the date column whenever a new item is entered in a different column, "Item", which is handy. The problem is that every time the worksheet is opened, every cell in the "Date" column that has a corresponding "Item" get updated to...
  3. S

    Automatically fill a cell just once

    I am making an invoice sheet which will include historical as well as current purchases. I auto-populate the date field with the current date when a new item is entered with =IF(F3<>"",TODAY(),""), where cell F3 is a cell for a new item name. My problem is that when I open the sheet...
  4. S

    Attach a comment to a data point in an Excel Graph

    I've added comments to graphs with arrows pointing to a specific data point, as for example, a point in time when some factor changed. It may offer an explanation of why the slope of a line changed. However, as additional data is added over time, the arrow is not linked to the data point, but...
Back
Top