• 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. C

    replace ddmmyy in all cells of a column with current day

    Re. your point 1. I think that trying to have a formula in a cell that acts on the very same cell always results in a circular reference error so I think you will need another column. Re. your point 2. I am not sure if I understand your question. Once you have the formula in cell B1 you can...
  2. C

    replace ddmmyy in all cells of a column with current day

    See this example: in cell A1 enter: aaaddmmyybbb in cell B1 enter this formula: =REPLACE(A1,SEARCH("ddmmyy",A1,1),6,TEXT(TODAY(),"ddmmyy")) If your workbook automatically recalculates when you open it this should always give you the current date as ddmmyy. This is what I get as a...
  3. C

    Need help : Macro for combination of number that sum/match to a value

    Hi Nang, This kind of number matching problems can take a very long time to resolve in a macro. There is a function in Excel that gives you the number of combinations of your transactions that should be checked looking for your sum. For example if you need to check if there are combinations...
Back
Top