I have two sheets, the “info” sheet and the “about” sheet”
I want to fill Column D in the "info" sheet with the copied data from Column D in the "about" sheet, but without any duplicates.
Duplicate names have to be hidden or removed in the about sheet.
how to do it?
MacBook Pro 15″, macOS 11.4
A couple of ways in recent versions of Numbers that make it easy to quickly remove duplicates:
First way. Filter. Apply an 'Is Distinct' Filter, select the visible cells in the column, command-c, click once in a destination cell in an existing table, and command-v or Edit > Paste and Match Style.
Second way: Pivot Table. Click in the table that has duplicate values, in the menu go to Organize > Create Pivot Table > On Current Sheet, and in the Pivot Options pane that appears drag the relevant "filed" down into the 'Rows' box like this:
Then select the de-duplicated values visible in the column, command-c, click in a cell in the destination table and paste as above.
SG
A couple of ways in recent versions of Numbers that make it easy to quickly remove duplicates:
First way. Filter. Apply an 'Is Distinct' Filter, select the visible cells in the column, command-c, click once in a destination cell in an existing table, and command-v or Edit > Paste and Match Style.
Second way: Pivot Table. Click in the table that has duplicate values, in the menu go to Organize > Create Pivot Table > On Current Sheet, and in the Pivot Options pane that appears drag the relevant "filed" down into the 'Rows' box like this:
Then select the de-duplicated values visible in the column, command-c, click in a cell in the destination table and paste as above.
SG
Maybe you can refer to this thread discussing about how to remove duplicates.
Everyone is how to delete repeating value… - Apple Community
2 sheets, Remove duplicates from 1 sheet.
