Search results

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

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.

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

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

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

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

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

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

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

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

@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.

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.

@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...

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

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)...

@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 )...

@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.

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

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.

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

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.

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

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

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

@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.