Search results

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

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

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.

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

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

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

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

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

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

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

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

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

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

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.

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.

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

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

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

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.

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

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

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