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

    My superpower? Making charts from data no one understands.

    My superpower? Making charts from data no one understands.
  2. ashakantasharma

    Pivot tables: Turning data chaos into clarity.

    Pivot tables: Turning data chaos into clarity.
  3. ashakantasharma

    Excel: Where every mistake is an opportunity to learn… and swear.

    Excel: Where every mistake is an opportunity to learn… and swear.
  4. ashakantasharma

    If at first you don’t succeed, try Ctrl+Z.

    If at first you don’t succeed, try Ctrl+Z.
  5. ashakantasharma

    I have a love-hate relationship with Excel… mostly hate when the formula breaks.

    I have a love-hate relationship with Excel… mostly hate when the formula breaks.
  6. ashakantasharma

    Spreadsheet ninja: Making sense of chaos, one cell at a time.

    Spreadsheet ninja: Making sense of chaos, one cell at a time.
  7. ashakantasharma

    Excel users do it with formulas.

    Excel users do it with formulas.
  8. ashakantasharma

    VLOOKUP: Because guessing is not a strategy.

    VLOOKUP: Because guessing is not a strategy.
  9. ashakantasharma

    Keep calm and let Excel do the math.

    Keep calm and let Excel do the math.
  10. ashakantasharma

    Excel is like a puzzle — but with more crying.

    Excel is like a puzzle — but with more crying.
  11. ashakantasharma

    Ctrl + Z is my best friend.

    Ctrl + Z is my best friend.
  12. ashakantasharma

    In Excel we trust — until the #REF! shows up.

    In Excel we trust — until the #REF! shows up.
  13. ashakantasharma

    Excel: Where ‘one wrong formula’ ruins your whole day.

    Excel: Where ‘one wrong formula’ ruins your whole day.
  14. ashakantasharma

    Without Excel, I’d be lost… literally.

    Without Excel, I’d be lost… literally.
  15. ashakantasharma

    Excel is my second language.

    Excel is my second language.
  16. ashakantasharma

    Why does entering =+$418M in Google Sheets cause a #ERROR?

    Hi everyone, When I enter =+$418M in a Google Sheets cell, it returns a #ERROR. Why does this happen, and how can I properly input or format large currency values like $418M without errors? Thanks in advance for your help!
  17. ashakantasharma

    It’s Excel’s world, we just live in it.

    It’s Excel’s world, we just live in it.
  18. ashakantasharma

    Microsoft Excel takes 8085002100000259 as 8085002100000250 which caused fund transfer to wrong Bank Account

    Hi All Community Members, I would like to share a strange problem with Microsoft Excel. We tried to initiate some Bill Payments to our Suppliers for which an Excel Sheet needs to be filed with Supplier bank details like Account Number, IFSC Code, Amounts etc which gets uploaded at Bank Site to...
  19. ashakantasharma

    excel hanging

    Get an i3, or i5, Switch to 64bit Office, Increase RAM, Close unnecessary applications.
  20. ashakantasharma

    Workbook Saving issue

    I think the Excel File is marked as READ ONLY and so it is not allowing to change the core/base file and letting the user SAVE AS with a different name. Please check the file properties of the Excel File and change any read only option which should resolve your issue.
  21. ashakantasharma

    Extract first letter from each word in cell

    https://www.mrexcel.com/board/threads/extracting-first-letter-from-each-word-in-a-cell.656277/
  22. ashakantasharma

    Extract first letter from each word in cell

    In Excel, you can create a User Defined Function to extract the first letters of every words in a cell. Please do as this: 1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window. 2. Click Insert > Module, and paste the following code in the Module Window.<...
Back
Top