Please does anyone know if I can use pivot table to bring out unique values.
I have thousands of rows and columns with firstname, middlename and lastname.
Some names are duplicate and I just want to bring out only unique names.

No. A Pivot Table can't tell the difference between "Fred Smith" and
"Frederick Smith". You will need to cleanse your data first.

Regards,
Fred.

"Yossy" wrote in message
...
Please does anyone know if I can use pivot table to bring out unique
values.
I have thousands of rows and columns with firstname, middlename and
lastname.
Some names are duplicate and I just want to bring out only unique names.

Hi Yossy,

Please does anyone know if I can use pivot table to bring out unique
values.
I have thousands of rows and columns with firstname, middlename and
lastname.
Some names are duplicate and I just want to bring out only unique names.

Do you just want a list of unique names?

Don't use a pivot table.

Select just the columns containing firstname, middlename and lastname, then
use Data - Filter - Advanced Filter

Check 'Copy to another location'
Check 'Unique records only'
Select a cell for the Copy to range

Done.

Ed Ferrero
www.edferrero.com