Grouping and Aggregation after Filtering

Below are sales amounts of some types of liquors. Find […]

Filtering Each Group

Below are monthly mean temperatures in a certain region […]

Keeping the First Record of Each Group

Below are access records of a website’s each section, y […]

Intra-group Sorting after Grouping

Below is a list of closing prices of a stock in a certa […]

Getting Computed Column after Grouping

Below is a food sales table which is grouped by the foo […]

Calculate through Multi-table Join

On the basis of a Standard Wage table, an Absence table […]

Comparison between Data from Multiple Sheets

In the sheet below, there is a list of top 15 universit […]

Creating Spreadsheets with Specific Formats

Here’s a list of scores for a gymnastics competition, w […]

Complex Computations in Categorized Tables

According to the box office revenue data of several mov […]

Calculating Intersection of Multiple Groups

Below is the scoring statistics of the recent 3 games o […]