Search results

Happy Diwali wishes to every one around the world. May the new year see all you formulas work and hopefully the results are what you were hoping for. And for Saturday Sal Mubarak for 1436 New Year - Hiriyah Kanti

I got this in an email from Charles Kyd I got the time wrong about the Microsoft event. Also many people were unable to connect to the Microsoft blog. So here's the exact announcement from Microsoft: "Join us Friday, April 4 at 1:00pm PDT/4:00pm EDT for the first Excel-hosted AMA (what’s an...

May all your formulas give the answer you want to see in addition to the correct answers in 2014. kanti

Hi Team, What is this poll, what is it used for. Is there any option other than OK?

It is that time of the year when we do a bit of reflection. I would like to wish the whole community of Chandoo a very safe and joyous Christmas. And would also like to thank everyone for expanding my limited knowledge of Excel. Kanti

Hi, Here is a Utility that i have been using, it copies from specified files and ranges in closed workbooks to a range specified in another closed workbook. cheers kanti

I am curious to know what others have put on their QAT as a starter I have the following: Paste Value New Workbook Open Document Location Camera Excel 2003 Pivot Wizard Insert/Delete Rows, Columns and Cells Form Calculator Clear (Filter)

I am not sure if this is the place to post this, but attached is a file that will help with Advance Filter. The VBA, in this case stands for Very Basic, but it works (I hope). regards kanti

Just saw a post today http://chandoo.org/forum/threads/filtered-table-from-another-sheet.13583/ what do we do here, politely refuse help on the one hand OR end up doing the whole assignment on the other? regards kanti

Hi, I am not sure if this is the appropriate place for this, but I would lke to wish everyone a very Happy Diwali

Hi, Are there any functions and commands in Excel that you feel should be used with extreme caution. I will start the list of with: Merge Cut and Paste As for Cut and Paste, I usually disable this if I develop a spreadsheet for others to use. Do you have any "Favourites"?

There are no limits to what you can do in Excel. Check out the following link http://kotaku.com/old-japanese-man-creates-amazing-art-using-excel-wait-499616608?goback=%2Egde_3843467_member_243837258

Check out the attached for a link to the Financial Modeling World Champioship http://www.dailydoseofexcel.com/archives/2012/09/04/the-2012-financial-modeling-world-championships/

Hi Chandoo, I would like to suggest that you include Time Based Calculations in your Tags list. There are a number of time based questions and more often than not, in some form or the other they have been fielded before. cheers Kanti

When copying Fomulas across columns that refer to the Table construct is it possible to make cetain columns absolute. Here is an example The original formula is : '=-SUMIFS(T_OpexBay[Nov],T_OpexBay[LOCAL_COST_ELEM_CODE],$A2,T_OpexBay[FASTER_BASE_LINE_ITEM],$AA$1) When I copy it to the next...