Search results

Hi Asheesh, Thanks for taking your time in looking into this but unfortunately I am not looking for formula method. I would like to have average calculations inside pivot table, even if it means doing the calculations in the rawdata as helper so that it can be called inside pivot table...

Hi everyone, Hope you guys are doing great! I was hoping if you could help me with this issue. Basically I am trying to add 7 day rolling average into pivot table and can't find a correct way to do it. Please find the attached spreadsheet where i've included the data I would like to include...

Please try this formula in cell B4: =IF(ISBLANK(VLOOKUP(A4,Words!A:B,2,FALSE)),VLOOKUP(A4,Words!A:B,1,FALSE),VLOOKUP(A4,Words!A:B,2,FALSE))

@Mubin Khwaja I am also quite keen on seeing the solution for this! Btw I have been trying to find the historical data for pulses prices changes. Could you give me few advice on where can I get this data please?

Thank you all for your help, I will try all the suggested formulae and will sure have few more questions so that I can understand the formula better :) @Somendra Misra, I would like to exclude blank data cells please, thanks. So for example if we have 2 blank cells in last 30 values the...

Hello awesome people, I have been trying to get this 30 day rolling average formulae working for few days now but couldn't so I was hoping if you guys could help me to the right direction please. I have also searched chandoo forum for this formula but couldn't find one which meets my criteria...

Morning Xiq, First of all, thank you very much for looking into my issue. Your formula works perfect!! would have never thought we could use substitute to solve this. Though I am not sure I understand your second formulae structurally. Would you mind explaining to me please, if you have some...

Thanks, below is the data: 1. IB - History - John - IN - Nov - 18-02 2. History - IB - IN - Paul - Dec - 01 3. IB - IN - Math - Jan - 14 - 20 4. PR - ENG - 30 - 01 - STU 5. IB - IN - Jan - Susan - 01 - 30 6. IB - IN - Math - 30 - 01 List of keywords need extracted in below format: IB, IN...

Morning Sajan, Thanks for taking your time in looking into my issue. Yes the Placeholder can be various strings, apologies for not being very clear... Is there any way around this? Kind Regards, Zoogle.

Hi All, I would like to get your assist on how to get multiple value from a text string. For example, my text string would look something like this: 1. A - B - Placeholder - C - Placeholder 2. A - D - Placeholder - B - Placeholder 3. A - D - Placeholder - Placeholder - B - Placeholder A, B...

Hi NARAYANK991, Thanks for explaining this in detail. I will be more careful next time to explain what I am trying to achieve in details as much as possible. Kind Regards, Z.

Hi SirJB7, Thanks for the reply. Is there anyway to achieve the results in cell C5 of this http://bit.ly/spreadsheet in excel ? A workaround maybe? Thanks for your time. Kind Regards, Z.

Thanks for the reply. @Debraj I am a big excel fan so no, excel is the best :D I was hoping something like =GetExternalData("URL") @Hui apologies, my bad... I am posting the link which I found on web and the formual I am looking after is =importdata(URL) and I was hoping to have something...

Hi All, Hope this message finds you well. I was going through google spreadsheet and found this formula and would like to use it in excel instead of using in google doc. Is there something similar in excel 2010? Thanks for your time. Regards, Z.

Hi SirJB7 & Smallman, You guys are stars! Thanks for taking your time in helping me out with this. Really appreciate your efforts and both of these solutions are perfect. @SirJB7 inclusion of Rank is pretty interesting, never thought of that.... Thanks again and have a very good weekend :)

Hi Smallman, Thanks for explaining this, very helpful. Of course, I will need to go through it few times to get it properly :) http://www.mediafire.com/?x7sv784sa9b3a64 I have attached the file so that you can see what the final output should be. What I am trying to achieve is to see the...

Hi Smallman, Thanks for the respond! Really appreciate and apologies for my cdiscrepancy between code. The attached document have correct wording as I had to amend my sheet to make it clean and forgot to update my pasted code in the previous post. Your code is awesome! I would like to...

Hi Excel Gurus, Thanks for reading this post in advance. I am stuck in middle of my automation process and needed some help and if you could that would be great!! What I am trying to achieve is as below: 1.grab comments or line of text from "raw tab". 2.Paste it in the summary tab at the...

Hi SirJB7, This formulae is awesome!! You are awesome as well :) I need to evaluate this formulae so that I "really" understand what is going on but Thanks again for the solution. Kind Regards, Z.

Hi Luke, Thanks for the solution, it works perfectly as usual :) I was wondering are there any formula which does not require text to column? Thanks for your time. Kind Regards, Z.

Hi Excel Gurus, I am having trouble converting this 05/01/2013 date format to 01/05/2013. Simply I am trying to convert US time format to UK time format, and I have tried quite a few formulae and no luck, it returns an error. As the source of the data is from a csv file, I think it is...

Thanks Narayan.

You are star Narayan. Thanks for this formula, it works like a charm! If you could also explain how formula works that would be awesome :) Thanks both to Hui & Narayan for taking your time to help me with this. Kind Regards, Z.

Sorry Hui, my apologies. I want to extract the last part of the string after last "_". So in this case that would be "5590f". So the problem with my current formula is that, in the string below 134562_ AA (br rbg) - 4457658994 - uutouir2039845_W1_Q1_Y35_553390f The result I want is...

Hi Excel Guru's, Hope you are all doing great! I would like to know how can I extract the last part of this string. The length of the string will vary and there could be unlimited "_" in the string. 134562_ AA (br rbg) - 4457658994 - uutouir2039845_W1_Q1_Y35_5590f For some reason the...