Double Filter (E100)

This example demonstrates how to use nested double filters to dynamically create a cross-query, instead of using the traditional INDEX and MATCH method.

Download Times: 0 | Upload Time: 2026-04-11 17:51 Download

Dynamic table fields

This file demonstrates how to easily use the filter function to dynamically display the checked columns, while also helping to understand the condition part within the filter function.

Download Times: 1 | Upload Time: 2026-04-11 17:54 Download

Auto update Subsheets (E99)

This example shows how to update a master sheet, with all the breakdown sheets updating simultaneously in real time.

Download Times: 0 | Upload Time: 2026-04-11 17:57 Download

Return the date when finished (E93)

Use the SCAN function to calculate the cumulative result, then use XLOOKUP to find the closest value corresponding to the date.

Download Times: 0 | Upload Time: 2026-04-11 17:58 Download

Donut charts with 3 layers (E67)

This chart shows detailed classification information using three layers, and is considered an upgraded version of a pie chart.

Download Times: 0 | Upload Time: 2026-04-11 18:00 Download