Removing Duplicates while leaving the blanks

T

tobetico

New Member
Joined
Jun 28, 2007
Messages
6
Hi,

I have a column with a set of duplicate values. I need to remove the duplicates while leaving the original data and keeping the blanks. The Remove Duplicates function comprises the data and this does not work for me. Help!
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Hi,

Could you clarify some issues?

-Sheet name
-Data range (column(s), rows)
-Data-type (text, numbers, mixed)
-Expected result

M.
 
Upvote 0
The following is the example of what I would like to achive, I have a lon list of order numbers on Column B, and I would like to see the unique order numbers on column A as follows. Any ideas?

A B
Unique
Order No Order No
8689792 8689792
8689792
8689792
8689792
8689792
8689792
8689792
8689792
8689792
8689792
8690850 8690850
8690906
8699723 8699723
8699723
8699751 8699751
8699756 8699756
8699758 8699758
8699769 8699769
 
Upvote 0
Is the following your desired outcome?

A B
8689792 8689792
8689792
8690850 8690850
8690906
8699723 8699723
8699723
8699751 8699751
8699756 8699756
8699758 8699758
8699769 8699769
 
Upvote 0
Hi, how do you want to macro it so it deletes them for you, or would a formula suffice?

This formula should do the trick, just copy it into B or whatever column:

=IF(COUNTIF($A$1:A1,A1)>1,"",A1)
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Solved
problem with code- removing duplicate rows
Replies
2
Views
142
heathball
H
D
  • Solved
Help with duplicates
Replies
7
Views
218
awoohaw
awoohaw
D
  • Solved
remove duplicate if cell appears twice macro
2
Replies
15
Views
515
daveyc18
D
divster27
  • Question
Creating a table to help remove duplicates
2
Replies
11
Views
110
bebo021999
B
T
  • Question
Remove duplicates
Replies
2
Views
103
tiredofit
T

Forum statistics

Threads
1,214,920
Messages
6,122,279
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top