Search results

Excellent work Indzara... I will share this with our readers this week (along with few other cool Excel links I saw in recent past) :)

Welcome back... :) You can still trump Luke for the 5k milestone

@Knockiiing.... Can you email me. We have a special template that allows you to set different currency (without changing all formulas and formats).

Hi Shaun... Interesting question. This is definitely possible with text formulas like FIND, MID & LEN. But I have a question before attempting the answer. Is your HTML source in one cell or in a column? (with each cell containing a TR element...?) If you have one TR in each cell in a...

Well, that is one tricky problem. I am not sure if my formulas are correct as the results are not matching with your manual calculations. But I think I got the approach ok (may require few tweaks). See the file. http://img.chandoo.org/playground/NannyShare_Hours_2013.xlsx My approach: 1...

@skidragon02: PowerPivot supports only one-to-many or one-to-one relationships. So one of the tables should have a unique values.

@Hi Ivan... Sorry I was traveling and could not look at your email earlier. Thanks for your purchase. Our templates do not have any WBS creator in them. But you can create a gantt chart or plan (once you have the WBS data) using our templates

@David... interesting question. I tried this using Pivot Tables. I could not get the exact result as what you wanted. But something very close. I was able to visualize % of accounts leaving by each month (opposite of retention). See this image...

@Robert... interesting find. This is done with drawing shapes & hyperlinks. First you create semi rounded rectangles with inside shadow. Then place them above table and color & shadow as needed in each tab. Then apply hyperlinks to each of them using Insert > Hyperlink feature. For...

@Narayan.. Thanks for your feedback. As this is my first quiz on the blog, I am still learning how to set it up and how to run it. I have use multiple "answer" questions to mainly test how many different ways our readers know. I was under the impression that when someone sees check boxes and...

@Kevin... why do you think so?

@Big d 51... have you read this? http://chandoo.org/wp/2012/04/26/adding-macros-customer-service-dashboard/

Hi Muhammad... see this post. Same idea applies to your situation as well. http://chandoo.org/wp/2013/03/06/finding-conversion-ratio-using-pivot-table-calculated-items/

Congratulations Luke... :)

Ooops.. I am wrong. You can do this easily by using "% difference from..." value field setting. Follow below steps: [list type=decimal] Add Sales to pivot values Right click on it, goto value field settings Go to show values as... Choose % difference from Specify Jan as base Click ok [/list...

@Scrasch... You can use % of calculation option to find out how much % of JAN sales are done in March. This is not exactly what you wanted, but almost similar.

Still same answer. Please search...

@Dec2Hex(3563) Interesting problem. I could get the values for everything except MRP lookups. Here is the formula. =SUMIFS($O$3:$O$11, $K$3:$K$11,A2, INDEX($L$3:$N$11,,MATCH(E2,$L$2:$N$2,0)), INDEX(B2:D2,MATCH(E2,$B$1:$D$1,0))) How it works? 1. We are going to SUM up the margin codes...

All this and no answer to Clevine's question or somehow it was answered and I missed it?!? @Celvine... Pivot table filters applied on different columns always act as AND. The easiest way to get what you want is to add a helper column to your source data and use OR formula there like...

To me Big data seems like a lot of marketing hype. Data did not suddenly become big. It has always been like that. Somehow BI companies have figured that Big data is the term that would drive more sales... See this recent piece by Stephen Few for more rant -...

Very interesting solution Hui. Thanks for posting. I made a tutorial on this today - http://chandoo.org/wp/2013/02/13/shaded-line-charts-excel/

You can try our templates, but these are desktop compatible only, not cloud based. Visit http://chandoo.org/pmt/pmt-index-1.html to get a copy

Hi Prazad... you can use AVERAGEIF for this. In C7 write, =AVERAGEIF($J$5:$J$13,$B7,K$5:K$13) and drag it down and sideways to get what you want.

@Haseeb & Kevin... Excellent (and super clever) solutions... :)

@Jb... Interesting question. Assuming it is a form control combo box, upon selection it will return the position of value selected. So you will get 1 for Sunday, 2 for Monday... 7 for Saturday. Then, use below formula to get to nearest weekday with that selection...