Search results

Hi NARAYAN, Thanks for the link, I am going to try as you've mentioned and will let you know how it goes. Please do let me know if you think there's any more approaches :) Kind Regards, Z.

Hi NARAYANK991, Thanks for getting back on me this. I have a hypothesis that if the weather is bad, people are going to buy to more of our products. We have actually seen this happening but I want to prove this by doing an analysis to see if this is really happening. I could as for a year...

Hi jdkshepard, In this situation what I would do is to count exactly how many formulae are in your spreadsheet and how many different functions (formulae types) are being used. After that, especially with the "if then" mega formulae I usually find it easier to copy the whole formulae in 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 chaosincarnate, I think you can just format the cell as Number and tick "use 1000 separator". This should give you the result you looking for. Regards, Z.

Thanks SirJB7 & Faseeh :) You guys are great ! Kind Regards, Z.

@Faseeh, thanks, your approach works as well. Since we have changed prod X comm to zero, the problem solves itself ? as mentioned in my formula. Please if you could enlighten me that would be great. You are star as well. hehee :)

Hi SirJB7, Thanks for this, lol small things are hard to spot. Trust me I tried alot of approach and the issue was "-" :) Below is the formulae which solves exactly my problem =SUMPRODUCT(($C$1:$P$1=D$16)*$A2:$A7*C2:P7) SirJB7 you are star, as always !! Kind Regards, Z.

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

Only one thing to say Chandoo. You are awesome !!

Thank you everyone for helping me understand this issue and offering solutions. Definitely looks like an bug/glitch in excel. Regards, Z.

@Narayank991 how strange it that. I tried sorting and then removing it and thus it removed all the duplicates. @Hui Advanced Filter also leaves it with Unique records. Not a problem Hui if you don't have time today. Any time will be fine. Thank you @Narayank991 & Hui for looking into this. If...

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 bhasoriya, You can refer to this awesome article on speeding up excel here: --> http://chandoo.org/wp/2012/03/26/excel-speedup-optimization-tips-by-experts/ If this doesn't help you can post an example of your spreadsheet so that we can all work on it to see the issue ? Hope this...

Hi Nawaz, Welcome to Chandoo ! I think you can do something like this by using Vlookup in combination with a helper column. Let me know if I have answered your question. Regards, Z.

Hi bhasoriya, Is it possible for you to create a dummy data sheet and upload here so everyone can help you with your request ? Regards, Z.

Hi jaydeepvyas2005, I would like to suggest you to try the same procedure with a completely new spreadsheet and see if the error persists. Or you can try sending the same file as a zip and see if it become unprotected automatically after the unzip. Let me know your results. Regards, Z.

Thanks Hui & John for the awesome ideas. I will try these techniques and will let you know the results. Let me know if you have more idea on presenting huge dataset. Regards, Z.

For me, main page is working and Custom google search not working.

Hi Fred, Apologies, I missed it in the spreadsheet. They are different product ID's, and % are performance by day. Thanks, Z.

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

Hi c_rahul001, Adding something more to what bobhc mentioned, is there any possibility that you could remove some duplicates from your list, if there is any. Cheers, Z.

Hi Maniche.Jain, This should help you to solve what you trying to do. http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ Cheers, Z.

Hi Pardha, Is this what you are looking for ? http://office.microsoft.com/en-us/excel-help/turn-on-autorecover-and-autosave-to-protect-your-files-in-case-of-a-crash-HP010354296.aspx Cheers, Z.

Hi Luke M, I must be getting blind or something, lolz. Thanks for the highlight. You are star !! Regards, Z.