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

    How to automate the Expiry Period by having irregular validity(yrs)?

    Dear Hui, thank you so much for replying my query. It really works for my model. Cheers!
  2. E

    How to automate the Expiry Period by having irregular validity(yrs)?

    Purchase Yr Purchase Month Validity (Yrs) Expiry Period 2011 3 0.75 ? 2011 3 1.08 ? 2011 3 1.45 ? 2011 3 2 201303 2011 3 5...
  3. E

    Hello .. Introduce yourself

    Hi everyone, I m elmer, from singapore. I am working as Financial Analyst in hospitality industry now. I m also involving in FX trading quite sometime using my own trading strategy which simply built upon excel and VBA. Hope to exchange all kind of excel and match ideas with you all here! Have...
  4. E

    How to remove the 2nd duplicated number between 2 fixed varibles in next column?

    Appreciated a lot! It works! Thank you NARAYANK991! Keep in touch! Elmer from Singapore
  5. E

    How to remove the 2nd duplicated number between 2 fixed varibles in next column?

    ultimately, I would like the above list to be shown as follows: A,B 0,3 1,0 0,0 0,0 0,3 1,0 0,3 0,3 1,0 0,0 0,0 0,3 1,0 0,3 0,0 0,3 1,0 0,0 0,0 0,0 0,0 0,0 0,3 0,0 0,3 Hence, between 3 and 3 in next column, there should be only ONE "1". My original list is below...
  6. E

    How to remove the 2nd duplicated number between 2 fixed varibles in next column?

    Dear Colleagues, May I ask how to solve aforesaid matters by having the following example? In this case, how to remove the 2nd "1"(or change "1" to "0") in column A which is located between the first and second "3" in column B. A,B 0,3 1,0 0,0 1,0 0,3 1,0 0,3 0,3 1,0 The above...
Back
Top