• 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


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

    Forum Migration Freezing on 23AUG2013 [IMPORTANT]

    This has been my avatar for almost 4 years. Am I missing anything :) ?
  2. K

    Forum Migration Freezing on 23AUG2013 [IMPORTANT]

    Hi All, The forum migration is underway and should be completed in next 24 hours or so. The process for converting from one database format to another is rather tricky, hence the delay. I will update you once we are ready to roll.
  3. K

    The LAST post

    Looks like we may take another 24 hours to have the new forum ready. Will update once we are ready... :)
  4. K

    The end of the world is nigh.

    Forgive me father, for I have sinned against you. Sometimes I use notepad++ to clean data instead of Excel.
  5. K

    Forum Migration Freezing on 23AUG2013 [IMPORTANT]

    All set for migration. Any time now our migration team will start moving bytes of our forum knowledge to new platform. Reg spammers I have cleaned our user database last night. We have now have only 6000 odd users (from original 76000 or so). My guess is very few spammers are retained in...
  6. K

    Forum Migration Freezing on 23AUG2013 [IMPORTANT]

    Hi all, Finally, our new forum software is ready. I am planning to migrate the forum data from old software (current platform) to new software on 23AUG2013 (Friday) at 10AM EST. Our forums will remain closed from that point until 26 August Monday Midnight (EST). What does this mean to you...
  7. K

    A new forum....?

    Thanks for excellent discussion and ideas folks. Here is how I am thinking about forum upgrade. 1. We desperately need it. 2. I do not want to go for a forum that has more fancy look. I like simple stuff and hence used bbpress in first place. Ideally, any new forum software we use will...
  8. K

    A new forum....?

    Hi all, As you may know, our forum has been under intense spam attack for last several months. This has not only slowed things on our site, but took considerable energy of our lovable ninjas and site admins. The problem for this spam attack is with us. We have been using a old...
  9. K

    IMPORTANT - Forum Registration Disabled [for next 10 days]

    Hi all, For several months now, we have been attacked by spambots which register and post spam on the forums. Just now I got an email from our hosting providers raising serious concern about this. As a preventive measure, I am disabling new registrations on the forum. This means, if you are...
  10. K

    Histogram Like Line in charts [SOLVED]

    Very interesting solution Hui.. Loved how using OFFSET you are able to generate all the numbers. Here is another solution using error bars. http://img.chandoo.org/playground/Red%20Line%20Chart.xlsx
  11. K

    Welcome Ramazan Karim!!

    @Faseeh and all our Muslim friends... Ramazan Mubarak Ho... @SirJB7... if you ever end up in India (may be a Chandoo.org ninja convention.. :P), you can eat Biryani at our house.
  12. K

    Pivot table showing unique first and last names

    One easy option is to create an extra column in original data like this, =firstname & " " & last name & " ("&date_of_birth&")" and use this column in pivot table.
  13. K

    Thank you!

    @Sajan.. congratulations on completing one year. I am sure many more agree with me when I say "your formulas are some of the most brilliant I have ever seen". I wish you many more years of knowledge, happiness and passion in our forums. @SirJB7: Golden iPads...? I shipped 2 to you when you...
  14. K

    Updated Post - Please Read

    The big challenge is we are using an outdated version of forum software. We cant update it as the developers abandoned bbpress almost 2 years ago. Adding any features like recaptcha has to be done by messing with old, unmaintained PHP code. That is why I am hesitant to do it. When I asked my...
  15. K

    Updated Post - Please Read

    Very interesting discussion. @Hui: thanks for taking time to update the rules. @Other ninjas and commenters on this thread: I think most of us answering questions derive a lot of pleasure solving a technical problem and comparing notes with fellow Excel users. So as long as you (answerer)...
  16. K

    Compendium of Chandoo.org forum posts

    @All ... this is a good idea. I too felt that we should preserve some of the Excel gems in our forum. Since there is no organized way to do it, I used "favorites" feature to add interesting discussions to my favorites. (see them here: http://chandoo.org/forums/profile/keymaster/favorites )...
  17. K

    Sum of top 3 records based on filtered criteria

    @acpt22 and all: I loved this question. So I made a video tutorial and article out of it here: http://chandoo.org/wp/2013/05/17/sum-of-top-3-values-meeting-criteria/ You can download example workbook, watch solution video (that shows how to write formulas or set up pivot table) too.
  18. K

    Congratulations NARAYANK991 4,000 Posts

    Congratulations Narayan... Thank you so much for being a part of Chandoo.org and sharing your knowledge with all of us.
  19. K

    Congratulations Hui 5,000 Posts

    congratulations Hui... This is a great achievement. I am really thankful to you for all the things you share here and teach me and countless others.
  20. K

    Some interesting analysis of Chandoo

    Interesting Old Chippy. To make it accurate, let me share few more numbers. In April 2013, we have 1.57 mn page views on blog portion of site. (it was 1.19 mn in April 2012). We have another 250k views in forums (compared to 110k views in forums in April 2012). We also have 66,000 RSS...
  21. K

    Automation of a Puppy Weight Chart

    that would be a honor. But I guess he has figured out better names for those already. PS: If we get a dog (which should happen when I go back to India in August), I am going to call her INDEX.
  22. K

    Conditional formatting for due dates and over due dates

    See this please - http://chandoo.org/wp/2012/05/22/highlight-due-dates-excel/
  23. K

    blog view

    May be ahhhmed is using one of those very large phone + tablet + PC combination devices that has 13 inch screen. It might look like a pc, but it is a phone :p PS: I would try if someone has turned on mobile mode (by changing user agent) in your browser. If so, you can google and find steps to...
  24. K

    How do you create this chart?

    You can do this by mixing regular column chart with a line on secondary axis (that has a very large negative minimum) and by hiding negative secondary axis labels. See attached. Examine the chart format and structure of input data for more...
  25. K

    Power Pivot Problems

    @Bphohn76.... Did you create any measures first? If not, try creating simple SUM or COUNT measures. When you drag and drop fields directly into values area, PowerPivot may struggle as you have such large amount of data.