How do I remove duplicates in Mac Numbers?

Asked By Charles Webster 10 points N/A Posted on - 04/02/2013

Hi there.  I have a database of names, addresses and phone numbers with a lot of duplicate entries in Numbers.  How do I remove duplicates in Mac Numbers?  I'm on OSx Mountain Lion and Numbers 2009.  Thanks in advance.

• Status: Open
• Question Views: 15965
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: Appletalk

Best Answer by

Go To Solution

Answered By Willis K White 50 points N/A #139432

How do I remove duplicates in Mac Numbers?

Hello,

I found these; you want to know about “how to remove duplicates in MAC numbers”

Please check these out web sites below.

You can visit these below web sites; hopefully you will know and find also videos.

No. 1: Apple Support Communities

No. 2: MacMost Forum

Thank you.

Willis K White.

About Willis K White

Questions
30

Answers
12

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 04/18/2013
• Question Category: Appletalk

Best Answer

Best Answer

Answered By points N/A #139433

How do I remove duplicates in Mac Numbers?

Hello,

The easiest method to do this task is to sort out the sheet and remove the duplicates manually.

1. Sort the column.

2. Add a formula like this: “B1=IF(A1=A2,"" ,A1 )”

3. Copy this to all cell in the column.

4. Now, copy column B and paste into column A.

Done.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 11/08/2013
• Question Category: Appletalk