In Excel 365, the “Unique” function filters out repeated items, showing only those appearing exactly once, while the “Distinct” function lists all distinct items, regardless of frequency.