Search results

As you Hui says, Forums have played a major part in reducing site comments. Many people now reach here to ask questions than ask them on post pages. It would be fascinating to see similar analysis for forum data. But I will save it for a later date.

@Debraj... Thanks for the suggestion. I am investigating an easy option to implement this. Please give me sometime.

Thanks for the links. Btw, we do have an article on that. See here please http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters

@Luke: Welcome back. There are many (including me) who missed you. Btw, the contest is over, we have about 75 entries. I am processing them now & will publish results next week. @SirJB7: I do run btw. I go for 5k walk/run almost every day :D. I have a simple policy - workouts first...

Although I am yet to meet AUI, I can certainly sense a lot of PUIs (Posting under influence)... And if you ever get to use the floo network, can you send one of those bottles over. Remember, we don't have furnaces in India, so you need to send it thru one of them split ACs that are in my...

@Jason.. my bad. I am using Excel 2010 in which you can insert calculated fields from home ribbon itself. And yes, I hope to revisit Singapore, although not sure when. I will post an update on blog once the dates are finalized.

You can use Calculated Fields option to do this. Follow below steps: 1. Select any value field inside pivot 2. Click on from Home ribbon > Insert > Calculated field 3. Write the field name as Launch vs. Sold % (or whatever you fancy) 4. Write formula as ='Uncompleted units Launched...

Well, to update, I did search on bb-press forums & Add-ins to find if there is a simple way to do this. Unfortunately, no. That means, I need to write some php (and SQL) to actually add this feature to the forum (or hire someone to do it). Since I am vary of adding new features that can slow...

@Debraj & @bobhc ... wow, never knew that. So interesting find.

Interesting request. Thanks for starting the conversation Vijay. Personally I have been a database programmer & SQL ninja in my other life (as a software developer between 2002-2004 and later in 2006-07). I have been using SQL & various databases (Oracle, MySQL, SQL Server and of course...

Why not use conditional formatting to highlight the selected row / column. It preserves the formatting too. Follow these steps. 1. set up 2 cells (in a separate sheet) to keep track of selected row & column. 2. name these cells as selRow and selCol 3. In the sheet where you need...

@ Manish.. I took the liberty of changing your display name to Manish so that it fits in the column width available. Your email address & user ID remain the same. Just that at display it is changed. On closing topics, there is a way to close topics. At the bottom of the thread, you can see...

It would be on 14 circle, the closest number is 827. See this file: http://img.chandoo.org/playground/CircleNumbers.xlsx How it works: What we have here is, the circle sizes are an arithmetic series with 8 as gap. so first circle has 8, then 16, then 24. That means, for nth circle, the...

that is where Key master comes in. I silently watch from sidelines, learn a lot and see who is gossiping and who is helping :D @SirJB... You should call me. I may have those darned keys somewhere in the forum database.

When applying data validation, you need to select entire table column to set up the rule. for this, place your mouse pointer on the column and hover until it turns in to black down arrow. Click to select the column. Now apply data validation rule. This should make DV apply to new rows automatically.

interesting question. Although you can set up the whole rule in CF, using a helper column would make the formula writing simpler. Assuming your data is in A2:C12 (A1:C1 contains headings), in D2 write, =A2&IF(C2=SUMPRODUCT( MAX(($C$2:$C$12)* ($A$2:$A$12=A2)))...

Interesting... One way to look at this is to divide them by 1. For ex.: the % completion for 5 & 3 would be, (1/3) / (1/5) = 166.7%

Welcome to Chandoo.org forums. Assuming the date you want to test is in A1, write =if(median(A1,"12/1/11","3/31/12")=A1,"Prior Period",if(median(A1,"4/1/12","5/31/12")=A1,"Current Period","Outside Range")) Vist http://chandoo.org/wp/2010/06/24/between-formula-excel/ for more info on...

Did someone say beer? Have one on me Montrey. Congratulations on turning 24 :)

fantastic! Congratulations Faseeh. Can I feature this dashboard as an example on the blog? If you want to send me another version with dummy data, please do so.

Sorry if my post is too late for your deadline on 5th June. But here it goes. First up, congratulations on such effort. your dashboards looks classy and allows users to do powerful analysis without wasting too much time. Here are few suggestions I can think of, The headers ("Expenditure for...

Very elegant solution Luke :)

Hi there, Welcome to Chandoo.org forums. Thanks for your question. Assuming SQFT is in column A (A2: A9) & Price is in B2:B9, you can use the formula, =MAX(IF(AND(A2:A9>=3000,A2:A9<=3500),B2:B9, 0)) and press CTRL+SHIFT+Enter. This will give you maximum value for the range 3000,3500

yes, looks like there is some other problem pending and that is causing this. As mentioned earlier, I have no clue how to fix it. But hopefully Pothi, my web admin should be back to work now. So let pray that the site goes back up during the weekend.

Hi Sonya, Thanks for your question. Please take a look this video to understand how to work with the dashboard. http://www.youtube.com/watch?v=ic1Iw11eCxg