Pivot Table extraction Non-Repeated Records (5)-cannot be used for drop-down

Pivot Table extraction Non-Repeated Records (5)-cannot be used for drop-down

Key design points: no duplicates, pivot tables, drop-down options

Xiuxiu: Hum, although the pivot table is very strong, there are many weaknesses!

Ajin: Huh? -- Can you have such a deep understanding of pivot tables? You won't use it.

Xiuxiu: And! As you can see, although it can automatically extract the value that appears, it cannot be used as the data source of the drop-down option.

Ajin: Oh? Look. Well, it may be that the bottom right area of the PivotTable has data, so the cell is not empty. If you use the counta () function, you cannot determine the number of items.

Xiuxiu: Alas! Isn't pivot your strength? Don't even know this?

Ajin: Ah, it means that my understanding of pivot tables is not deep enough.

Xiuxiu: So, are you proud ?!

Ajin: Proud! Thank you!

Pivot Table extraction Non-Repeated Records (5)-cannot be used for drop-down