The surface chart is used to represent two dimensional data in 3D map. It looks like a topographical map. The higher values are shown as high peaks. I...
In Excel 2016, Microsoft presented two hierarchical chart types. Sunburst chart and Treemap chart. In this article, we will learn when and how to use ...
Some times we get the need of converting given column number into the column letter (A, B, C,..), since the excel addressing function works with colum...
It’s common to get errors in excel while doing the calculation using excel formulas. You can quickly fix an error if it depends on hardcoded values ...
Many times, like when we extract numbers out of string, they be text by property. You can’t do any number operations on them. Then we get the need o...
In this article, we will learn how to retrieve cell address of a lookup value. There will be times when you would want to get address of cell from ...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
