— The solution workbook related to this challenge solution can be downloaded from Solution – Challenge 23 – Make Bar Chart to Show Performance — Below is a possible solution to the challenge Challenge 23 – Make Bar Chart to Show Performance 1. Download the workbook from Salesman Performance Challenge 2. Select range A1:C7 3….
Category: Challenges
Challenge 25 – Prepare a Project Status Chart with Sliders
This time challenge is to prepare following chart for Project Status. I am not giving any Excel sheet for this challenge. Just think and be creative. You may post your solution in comments section. Note – Solution to this challenge will be published after 1 month i.e. on 11-Oct-15.
Solution – Challenge 22 – Another Friday the 13th Challenge – Find Actual Dates themselves
Below is a possible solution to the challenge – Challenge 22 – Another Friday the 13th Challenge – Find Actual Dates themselves If A1 and A2 contain the start and end dates, put following formula and drag down – =IFERROR(AGGREGATE(15,6,(ROW(INDIRECT($A$1&":"&$A$2)))/((TEXT(ROW(INDIRECT($A$1&":"&$A$2)), "ddd")="Fri")*(TEXT(ROW(INDIRECT($A$1&":"&$A$2)),"dd")="13")),ROWS($1:1)),"") A workbook illustrating the same can be downloaded from Solution – Challenge 22 –…
Solution – Challenge 21 – Male Female Pie Chart with Pictures
— The workbook related to this solution can be downloaded from Solution – Challenge 21 – Male Female Pie Chart with Pictures — Below is a possible solution to the challenge – Challenge 21 – Male Female Pie Chart with Pictures Download the files related to this challenge as given in the problem – Male_Female_Pie_Chart…
Challenge 24 – Sum a Range Conditionally where Range Inputs are variables
— Excel related to this challenge can be downloaded from Challenge – Sum a Range Conditionally — Suppose, you have values in column A and D1 and D2 contains the range references. D3 contains the condition value for greater than. In this example, you will need to sum up between A4 and A8 where values…
Challenge 23 – Make Bar Chart to Show Performance
This time challenge is to create a bar chart like below to show the Target Planned and Target Achievement. Related Excel you can download here Salesman Performance Challenge You may post your solution in comments section. Note – Solution to this challenge will be published after 1 month i.e. on 14-Sep-15.
Solution – Challenge 20 – Find Number of Friday the 13th between Two Given Dates
Below is a possible solution to the challenge – Challenge 20 – Find Number of Friday the 13th between Two Given Dates The formula for finding this would be – =SUMPRODUCT((TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Fri")*(TEXT(ROW(INDIRECT(A1&":"&A2)),"dd")="13"))
Challenge 22 – Another Friday the 13th Challenge – Find Actual Dates themselves
Challenge 20 was about finding the number of Friday the 13th between two given dates. This challenge is about actually listing down the Friday the 13th dates themselves. Suppose, you been given 2 dates. A1=1/1/2014 A2 = 12/31/2015 The challenge before you is to write a formula which can be dragged down and will list…
Solution – Challenge 19 – Make Comparative Horizontal Bar Graph
Below is a proposed solution to the challenge – Challenge 19 – Make Comparative Horizontal Bar Graph 1. Download the Excel sheet from the challenge. 2. Put "F" without quotes in D1 and put following formula in D2 and drag down =-C2 3. Now select A1:B9, hold CTRL and select D1:D9. 4. Insert the bar…
Challenge 21 – Male Female Pie Chart with Pictures
This time, you have a challenge to create a Male Female Percentage chart with pictures of Male and Female to denote the labeling of pie slices. There are 2 pie charts for your challenge. The files related to this can be downloaded from following links – Male_Female_Pie_Chart Excel File | Male Picture -1st Pie | …