Spil: Liste

: Dynamic array formulas often cannot "spill" inside a structured Excel Table if they are copied down every row.

: There is existing data or a merged cell in the way of where the list needs to go. Spil liste

These functions are the primary ways to generate a dynamic "Spil liste": : Extracts a list of distinct values from a range. : Dynamic array formulas often cannot "spill" inside

: Automatically organizes your list alphabetically or numerically. Spil liste

While "Spil liste" literally translates from Danish as "Game list," it commonly refers to in Excel, which create dynamic lists that automatically "spill" into adjacent cells.

: Creates a list based on specific criteria you define.