• 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

    SUM total using FIND from one CELL

    Hi Haseeb. Thank you very much, that was exactly what i needed! Cheers.
  2. E

    SUM total using FIND from one CELL

    Hi guys, Nice facelift to the forum! It looks awesome, cleaner and more user-friendly than a lot of others I'm part of! Congrats. Let's cut to the chase shall we :) I have a little problem, I am trying to find the total sum using find and other formulas, but I didn't have any luck so far...
  3. E

    Excel 2010: Can't view or select Sheet Shapes which are Visible [SOLVED]

    Sir!! Found the solution. Somehow, (I dont know how) the box in [ Options / Advanced / Display / Show all objects ] was not checked! Thanks for your attention and help! Rgds
  4. E

    Excel 2010: Can't view or select Sheet Shapes which are Visible [SOLVED]

    Hi SirJB7! Thanks for your reply, please find the info you requested below: EXCEL 2010 (14.0.6126.5004) SP1 MSO MS OFFICE Home and Student 2010 I still have no idea whats going on! ahhhhhhh
  5. E

    Excel 2010: Can't view or select Sheet Shapes which are Visible [SOLVED]

    Hello guys! I am having a bit of a problem, it looks like a bug of some kind! I created a smartart diagram in Sheet1 3 days ago.. It was working just fine, then, all of a sudden, it just didn't display the diagrams anymore! So I pressed ALT+F10 and I saw the shapes were still there (checked...
  6. E

    Replacing long/confusing/not-userfriendly calculation with something better!

    Sir, you are a gentlemen. Lol, will change the topic as advised! Thank you!!!!!!!!!
  7. E

    Replacing long/confusing/not-userfriendly calculation with something better!

    Hi SirJB7, Forgive me, but I sent you the wrong link! Please find the correct one below!!! Sorry!!! https://www.dropbox.com/s/i7sgh7wbvcd2e42/Schedule%20of%20Payments%20and%20Settlements.xlsb Best Rgds.
  8. E

    Replacing long/confusing/not-userfriendly calculation with something better!

    Hi SirJB7! Please find what I am trying to achieve in the sample below! https://www.dropbox.com/s/i7sgh7wbvcd2e42/Schedule%20of%20Payments%20and%20Settlements.xlsb Regards.
  9. E

    Replacing long/confusing/not-userfriendly calculation with something better!

    Hi Hui, Thank you for the reminder! Please find the link to the sample wkbook. https://www.dropbox.com/s/xiq9zcnwdpedl4i/Schedule%20of%20Payments%20and%20Settlements.xls
  10. E

    Replacing long/confusing/not-userfriendly calculation with something better!

    Hi all, I am having trouble trying to figure out another way to calculate my total ($) sum of settlements which is triggered through every 1st payment. I wish I could explain this more eloquently, so I built an example spreadsheet...
Back
Top