When will start looking for advice how to make Max If formula in MS Excel, most of the time you will get this example:
Where those curly brackets mean that this formula is an array formula. And while it is only one IF criteria, formula look fine. But lets add second criteria and we will get this formula:
Continue reading “MS Excel: Max If without If”
Here is one of the charts how to make date to look more interesting. With kind of chart we can show the progress of sales in different branches or any other progress between several competitors.
At the beginning let’s have simple table with 7 columns. In the first column should be names of the variables you want to compare. In the second column should target for every variable. In the third column are fulfillment to date. In the fourth column is progress. So basically in cell E4 is C4 divided by B4. In the fifth column is length of the progress bar (blue bar). As you can see it is one percent less than the progress as i chose to have slider 2 percents of the whole progress and it is fill by brown color. So that’s what it shows in the F. And finally in the column G is length of the whole progress bar.
Continue reading “Progress Bar Chart”