• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Connecting Adobe Ominiture data into excel

    Hi everyone! I was wondering if there's a way to get ominiture data directly into excel sheet? Currently I am downloading excel sheets and copy/pasting data in excel manually. Is it possible to do data feed/query so that I get data automatically. I was thinking about getting this data into...
  2. M

    How to password protect powerpivot workbook

    Hi everyone, Hope this message finds you all well :) I am trying to work out how I could password protect powerpivot/data model so that when I send my sheet to clients they won't be able to access the sensitive information in data model. I could encrypt the sheet with password but then it...
  3. M

    Where to ask/post for powerpivot related questions

    Hi everyone, I am not sure where I should post powerpivot related questions in the forum. Do we have a section for powerpivot only related questions? Thanks, Z.
  4. M

    PowerPivot DAX (calc field & column) help

    Happy New Year everybody, Hope you all had great fun. I would like to get you advice on few issues I am having with powerpivot DAX please. I am trying to achieve a calculated column which is basically a sumifs in excel language but not sure what I doing wrong. In the attached file I have...
  5. M

    Commodities (Pulses) Daily Breakdown data

    Hi everyone, Hope you all had great fun during the holiday seasons. I have been trying to find pulses data (for past 1-3 year) in daily breakdown format and having trouble where to find this info. Could you guys give me advice/suggestion on where I could get this info please? Thanks for your...
  6. M

    7 day rolling average in 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...
  7. M

    30 day Rolling Average

    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...
  8. M

    Finding multiple values in text string

    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...
  9. M

    IMPORTDATA(URL) in google doc

    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.
  10. M

    Remove duplicate, cut and paste columns VBA [SOLVED]

    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...
  11. M

    US Date format Convert Help

    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...
  12. M

    Extract last part of the string

    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...
  13. M

    Sales performance vs Weather (best way to analyse and display)

    Hi Excel Gurus, Hope you all are doing great. I know I haven't been very active on chandoo recently and it is due to various shifts in my occupation which required me to focus on other subjects rather than on excel and data analysis. My apologies for this :) I was doing this analysis and...
  14. M

    Multiple column multiply sum

    Hi Excel Gurus, I would like your help on solving the issue I have with multiplying columns and then sum the results. As there are too many columns I can't keep changing formula always. I need a dynamic formula to do the calculation. Please refer to the attached spreadsheet for more...
  15. M

    How to remove duplicate from a integer,integer+txt values

    Hi Excel Guru, Today I was trying to remove duplicates for analysis purpose and I came across a situation where I couldn't remove any duplicate using built-in duplicate remove. I believe this issue is caused by inclusion of integer and integer+txt data in the list, excel is getting confused ...
  16. M

    How to present 50 different variables in %

    Hi Excel gurus, I was doing this analysis where I have 50 different variables (columns) and they are %calculated (between 2 variables) on daily basis for 5 months (152 rows). Now I am confused what would be the best way to present the data in a way that would stand out. 50 different...
  17. M

    Weather dataset day/day hourly

    Hello All, Anyone can help me guide where can I find a dataset for previous month/day weather reports for UK by day/day & hourly breakdown ? All I can seem to find is forecast, monthly or yearly dataset. Thanks for your time. Regards, Z.
  18. M

    Treemapping in excel ?

    Hi All, Is it possible to do Treemap in excel ? If yes can you kindly point me where can I learn about this please. http://en.wikipedia.org/wiki/Treemapping Also can you help me defining what will be a good example of hierarchical data ? Thanks for your time. Regards, Z.
  19. M

    List box (form control) help

    Hi all, I am having problem with using List box (form control). What I want to do is to be able to multiselect the lists and count the numbers from the lists which users have selected. So if users have selected 3 then the output will be 3. I am able to do that with combo box (form...
  20. M

    Getting data before space

    Hi All, I was trying to clean the raw data and faced a situation which I need help. Raw Data abc 1 abcd 11 abc 22 abcde 14 The len is not constant. How can I just get the data before the space using a formula. So the result after the formulae would be: abc abcd abc abcde I...
  21. M

    Multiple criteria matching multiple criteria

    Hi all, I am trying to match multiple criteria based on multiple criteria and return a sum value on that. I can't use sumifs formulae because the multiple criteria is in one column. Please look at the sample data below: Raw Name Cost A 14 B 156 C 564 D 312 E 21 F 224 G 157 Result...
  22. M

    What is Database functions how to make use of them ?

    Hi All, I am just curious about these database functions and was wondering how can I make use of them. Is there a link or something where I can learn more detail about these functions and which raw data to work on ? Cheers, Z.
  23. M

    File Size issue Maximum row issue

    Hi all, I was wondering is there any way to decrease the size of the spreadsheet with 300,000 rows of data and increase calculating speed ? I've used very simple formulae to ensure the increased performance but its ever growing data is causing big problem. Also what if I reach the maximum...
  24. M

    Single Criteria Multiple Value return

    Hi All, Hope you all doing great. I've got a question which has been bothering me for days now. This can be done using either pivot table or VBA but what I want to find out is how to drive the same results using formulae. Assume that we have value as below in Sheet1: Name Cost Code...
  25. M

    Web query

    I am trying to get the table from a web page direclty. This is first time I am learnin/using this function and haven't quite got a grip on it. The problem is that there are some occasions that it won't let me select data. Also I can't even select what data I want. It let me select the whole...
Back
Top