You'd think a team working on Formula 1 cars would be using advanced software, but nope... it's been discovered that an F1 team has been using Microsoft Excel for the Williams car build workbook.

FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can nest FILTER inside SUM or AVERAGE formulas to calculate values from filtered ...