Rank scores, sales or times in Google Sheets with the RANK function. Worked example with 12 students, how ties are handled, ascending ranks, RANK.AVG, unique ranks and common errors.
Tag: Google Sheets tips
DMIN Function in Google Sheets (With Example)
Learn how the DMIN function in Google Sheets returns the lowest value for rows that match a criteria block. Worked example with real numbers, AND/OR criteria, five variations and common errors.
Birthday and Anniversary Tracker in Google Sheets with Search Feature
A Birthday and Anniversary Tracker in Google Sheets that counts the days left to every occasion and lists what is coming up in the next 7, 30 or 90 days. See each sheet, the Remaining Days formula and how to set it up.
Sparklines in Google Sheets: Line, Column and Win/Loss Examples
Learn the SPARKLINE function in Google Sheets with three worked examples: a line sparkline for daily sales, a column sparkline for quarterly margin and a win/loss sparkline for attendance.
3D Doughnut Chart in Google Sheets: Step-by-Step Guide
Build a dynamic 3D doughnut chart in Google Sheets from a pie chart, two data cells and one helper formula, with the KPI value shown in the centre of the ring.
Pivot Table Guide for Google Sheets (3 Step-by-Step Examples)
A practical pivot table guide for Google Sheets: build three real summaries from a sales dataset (totals by product, country and product metrics, and percent of sales by segment), plus calculated fields, date grouping and fixes for common problems.