How do I remove duplicates in Mac Numbers?

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by RubyIslam3
Answered By 50 points N/A #139432

How do I remove duplicates in Mac Numbers?

qa-featured

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.

Best Answer
Best Answer
Answered By 70 points N/A #139433

How do I remove duplicates in Mac Numbers?

qa-featured

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.

Login/Register to Answer

Related Questions