Microsoft Excel is a powerhouse data management ... it must be used somewhere in the LET function’s calculation. The UNIQUE function scans a list of values and returns only the distinct ones.

A100), and Excel will write down the unique customer names in the cells below B1. SWITCH is a powerful logical function that ...