Hello Everyone,
I want to share a new Dashboard that I have published - 2016 Olympics results in an interactive dashboard.
Free Download:
https://indzara.com/2016/08/excel-dashboard-2016-olympics/
Key Features
Dynamic One-Page dashboard that adapts to user selections
All the medal...
Thanks for sharing. It is great to show data for all world cups. I don't know VBA. I am assuming you are extracting the data from somewhere online automatically. That's very impressive. :) One day, I will try to understand how to do it.
Best wishes.
My first attempt to capture a Cricket tournament in Excel.
http://indzara.com/2015/04/cricket-world-cup-2015-free-excel-dashboard/
I look forward to hearing your feedback. Thank you.
Thanks for the instant response. I was able to run Office Repair from Control Panel and all three versions started working. Then again, after a few days, Excel 2013 is not opening.
I agree with you that having multiple versions is not a good idea. I build templates and publish at...
I have Excel 2007, 2010 and 2013 installed in my Windows 7. In the main user profile, I can use any of the three versions, but in another user profile, Excel 2013 is not available at all. Is there any setting I need to modify to fix this? Any help? Thanks in advance.
@Debraj Roy and @nazmul_muneer
Thank you. I will continue to contribute more. The solutions I create are posted here: http://www.indzara.blogspot.com/ It will be great to get your reviews.
@Chandoo - Thanks. I look forward to feedback from your readers. I have found your site to be a great...
Hello Everyone,
Do you create geographic heat maps for India in Excel or do you use other applications for that? I tried the Bing Maps application for Excel and couldn't get it to provide a heat map.
I created one (http://indzara.blogspot.com/2013/04/geoheatmapindia.html) myself in Excel...
Thanks for the instant reply. I was amazed at how quickly the community responded. I am sorry that my response is a delayed one.
I traced the problem to a rounding error. The two cells H7 and H8 in my example had formulas that were counting number of unique values in a range with different...
I have two cells with the following formulas.
Cell 1: SMALL(Tbl_Project_List[[#Data],[Priority]],H7)
Cell 2: SMALL(Tbl_Project_List[[#Data],[Priority]],H8)
Both H7 and H8 have the value 1. So I expect the same result in Cells 1 and 2. However, I get a correct value in Cell 1 and a #NUM...