I have excel 2013 which do not has Power Pivot add-in enabled. I searched google for add-in to download but nothing found. Please help me with the link where I can download it.
Hi,
I have a few text files (.txt) which have data in English and Chinese languages. I am required to consolidate these files.
I am able to do that successfully however; while reading Chinese language data and pasted it to Excel, Chinese alphabets becomes some special characters i.e. do not...
Dear All,
I am trying to make similar charts as shown in the attachment but don't know to make them in Excel. Tried a lot searching on google but got no success.
I viewed them on internet so don't have data so just uploading the picture that I captured from there.
Hoping to get a solution...
Hi all,
Yesterday one of my team member showed me an error he was getting in a report. This is very strange kind of error which I never heard from anyone nor faced it. Also, unable to replicate it. However, seen it on my colleage's system. We tried to fix it but no success :(
1. there are 4...
Hi All,
First time accessing this new version of the forum and happy to find that we can upload sample data now. It will help a lot in my future posts. Thank you so much Chandoo:)
I was reading a topic on google (link ...
Hi All,
Please help me with VBA code so that I can login to a web based application. For example, I need a code to login to my gmail account by running a macro in Excel.
Thanks,
Dheeraj
Hi All,
Whenever we open an Excel Workbook, in backend another workbook named personal.xlsx opens. Kindly help me to find its path using VBA and make it visible so that I can save my VBA codes in its module so that they are available to me all the time.
Thanks and regards,
DJ
Hi,
I tried using dynamic charting technique at below link but when I insert a picture and try to type namedrange, excel doesn't let me do it.
http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/
However, when I copy the picture used in downloaded file from this link, it works...
Hi All,
I have a situation in which based on a condition I need to get total from multiple columns. Below showing sample data:
Column-A Column-B Column-C Column-D
Person1 5000 10000 15000
Person2 5000 5000 10000
Person2 4500 20000...
Hi All,
I use Excel 2007 and in my report can have data of over 800000 rows and 30 columns. We have created around 10 to 15 pivots using this data. I know creating these many of pivots is a sin but it is required.
Since every Pivot table saves data with the table layout by default, file size...
Hi All,
I am unable to understand the formula explained at the following link However, it is working fine:
http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/
Let me explain the problem:
1. Syntax for Countif is...
Hi Masters, thank you for this wonderful website. It is really helping me to learn new everyday.
Kindly assist with the basics of VBA programming so that I can link Excel with other applications for example If I want to mark my attendance in our HR tool when I reach my office and without...
I have come to know that Vlookup function's fourth argument can have values other than 0,1 and 3. Kindly assist me with the different values that this function can have and their usage.
Thanks
Dheeraj
I want to learn VBA to create macros. I am a bigginner and can create small macros using Excel Macro recorder to perform some repetitive tasks but that is not enough.
Actually I wish to learn VBA coding from scratch. I hope you will help me providing some study metarial by giving some...