Pivot table : count unique values, duplicate values as 1
To count duplicate values as 1 in a pivot table of excel, follow these steps: 3. Place the field you want to count 4. In the values area (more options), …
Tag: 중복값 제외 카운트
excel formulas, excel functions, excel shortcut keys