Sat 26 Aug 2017

## Downloads 18 - Sample CSV Files / Data Sets for Testing (till 1.5 Million Records) - Sales

Disclaimer - The datasets are generated through random logic in VBA. These are not real sales data and should not be used for any other purpose other than testing.

You can download sample csv files ranging from 100 records to 1500000 records. 1.5 Million records will cross 1 million limit of Excel. But 1.5 Million Records are useful for Power Query / Power Pivot. These csv files contain data in various formats like Text and Numbers which should satisfy your need for testing.

This data set can be categorized under "Sales" category.

Below are the fields which appear as part of these csv files as first line.

Mon 14 Sep 2015

## Solution - Challenge 23 – Make Bar Chart to Show Performance

By |Monday, September 14th, 2015|Categories: Solutions||0 Comments

-- 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

2. Select range A1:C7
3. Insert > Chart > Choose the appropriate bar chart. You will get the chart like below -

Sat 15 Aug 2015

## Challenge 23 - Make Bar Chart to Show Performance

By |Saturday, August 15th, 2015|Categories: Challenges||1 Comment

This time challenge is to create a bar chart like below to show the Target Planned and Target Achievement.

Note - Solution to this challenge will be published after 1 month i.e. on 14-Sep-15.

Mon 13 Jul 2015

## Solution - Challenge 12 – Student Scoring Maximum Total Score

By |Monday, July 13th, 2015|Categories: Solutions||0 Comments

Below is a proposed solution for the challenge Challenge 12 – Student Scoring Maximum Total Score

Put following Array formula in N2

=INDEX(A2:A20,MATCH(MAX(MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0))),
MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0)),0))

Put following Array formula in N3

=MAX(MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0)))

The solution sheet for this can be downloaded from Solution - Challenge 12 – Student Scoring Maximum Total Score