Search results

Hi Mattlsmith, Thanks for your purchase and welcome to our forums. As a start, I recommend seeing the 3 green sticky threads on forum home page here: http://chandoo.org/forums Coming to your question, you can easily add the column to gantt chart, but integrating it in dashboard takes a bit...

Welcome to our forums Garth & thanks for posting your question. As a first step, I recommend you to spend sometime going thru 3 green threads on forums main page - http://chandoo.org/forums Also, you may join our newsletter - http://chandoo.org/wp/subscribe/ Coming to your question, I do...

@CB.. you can use a custom format rule to hide 0s in the display. For this, 1. Go to value field settings of your calculated field. 2. Click on number format 3. Select format type as Custom 4. Type General;;; 5. Click ok and close everything

I do not think Camera tool snap shots work across workbooks.., I just tried it and it does not work in my version of Excel (2013).

@ccowman... 1. The image is just a special symbol from font (insert > symbol) 2. The lines are result of enable grid lines on the calculation sheet. Also, once you hide grid lines (from view ribbon), try to scroll down / up on the dashboard or change some selection. This will force the...

Congratulations Bob... Wishing you many more 1000s of forum posts :)

@David... I think using a clock metaphor for this will make it hard to read for below reasons: Clocks contain only 12 hours, where as a day contains 24 Once you add more than a few members the chart looks very busy That said, it is an interesting idea. So I made a small example...

Also, please check out - http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/

Also refer to http://chandoo.org/wp/2009/09/22/elapsed-time-excel/ for several examples on this. PS: Please title your questions accurately. "Chandoo I am your new user... " sounds much like what my daughter says for everything... "Daddy, I want..."

@Jerome... I do not think this is possible directly. Then again, I am a PowerPivot noob, so I may be wrong. So here is an alternative approach: 1. Set up your A5 as a table 2. Link it to power pivot 3. create a measure that points to the table value (since a single value is there, you...

You can not edit or delete anything from Power Pivot tables. You can restart by deleting the table in pp and recreating it from scratch.

The high level (project level) indicators are fed by column J in the "Project Details" tab. The project activity level indicators are from % done column in respective project plan in "project plan" tab.

A good place to start might be to visualize ABC conjecture. I tired it a few months ago when there was news about it (http://news.sciencemag.org/sciencenow/2012/09/abc-conjecture.html and http://en.wikipedia.org/wiki/Abc_conjecture ) Alas, there wasn't enough carlsberg to get me thru it.

@Deny... PowerPivot relationships must be one to one or one to many only. It does not support many to many replationships. In your case, customer ID must have been repeated in both sales & invoice tables. Here is what I suggest: Link sales to customers table (unique list of customer...

@Scott.. Welcome to Chandoo.org and thanks for your posting your question. I suggest you to know our forum rules better by reading 3 sticky posts on the home page - http://chandoo.org/forums Also, Please join our newsletter so that you can get latest tips & tutorials by email. Visit...

@Murali... Instead of using slicers on values, here is what I suggest: create an extra column in your original data and fill it with YES if any one value is not zero and NO other wise. Then add a slicer for this new column in your pivot. This should fix the problem.

Cacos... you can do basic sentiment analysis very easily with Excel. I have done it several times (you can see example in this page - http://chandoo.org/wp/2012/07/19/analyzing-20000-comments/ ) The approach I suggest is (as Hui mentioned), - list all words & synonyms of the sentiment you...

IF you want to just learn the SQL statements (mainly SELECT statements & Various combinations), best option would be to pick up the syntax & examples by searching the web. Once you know the basics, install a database (MS Access or MySQL), dump a few tables and start playing. Put yourself in the...

You are right Narayan... I found that Solver is excellent for solving linear or usual optimization problems, but is very poor when it comes to integer or binary problems. I am sure a brute-force (or any other search) program can reveal the best possible 5 location combination.

Following Narayan's lead, I think we can use solver to find the optimum. My assumptions are, - You want to find any combination of 5 locations that lets you complete maximum number of jobs. A job is completed when all its locations are in the 5 locations selected. - You do not mind if a...

@Shrivallabha... Good solution. @RMajare... try this formula (array entered) instead. =IFERROR(INDEX(NameList,SMALL(IF(ISNUMBER(FIND(NameList,$A2,1)),ROW(NameList)),COLUMNS($B2:B2))-1),"-")

I am not sure I understand your question. Please note that COUNT formula only counts numbers in a range. if you want to count all values (including text etc.), use COUNTA

A chat room eh!!! :P Good suggestion. This adds to the reasons why we should migrate our forum to a new platform. I am not even aware of any functional chat plugins for our forum software. So let me research that and reply to you. @SirJB7.. I did not know you had diamonds hitting you when...

If you have Excel 2007 or above, leave it to Excel to remove the duplicates. There is a built-in feature called "Remove Duplicates" in data ribbon that can do this with just a click. In case you want to automate it thru VBA, below code helps. Sub removeDups() ' Remove duplicates in the...

See this please: http://chandoo.org/wp/2010/11/10/vlookup-second-value/