Duplicates

zacemmel

Well-known Member
Joined
Apr 29, 2002
Messages
636
I have seen several posts on the forum regarding duplicates. Most peope resort to UDFs and VBA to remove duplicates. That isn't neccesary. You can remove duplicates with the functions that are built-in to Excel.

Check out the formula I created below:

=IF(ROW()=ROW($A$1),$A$1,IF(ISERROR(INDIRECT("a"&MIN(IF(MATCH($A$1:$A$13,$A$1:$A$13,0)>MATCH(B1,$A$1:$A$13,0),MATCH($A$1:$A$13,$A$1:$A$13,0),99999)))),"",INDIRECT("a"&MIN(IF(MATCH($A$1:$A$13,$A$1:$A$13,0)>MATCH(B1,$A$1:$A$13,0),MATCH($A$1:$A$13,$A$1:$A$13,0),99999)))))
This message was edited by zacemmel on 2002-05-02 11:02
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
What a cluster! How in the world did you come up with that one?

Good job if it works.
 
Upvote 0
HELLO THERE ZACEMMEL

PLEASE EXPLAIN TO ME HOW ARE THE DUPLICATES
REMOVED WITH THIS FORMULA?

REGARDS

ANDREAS
 
Upvote 0
I'm stumped at why you think this formula (or any formula) would remove duplicates since formula do not modify the contents of the spreadsheet they only return a result.
 
Upvote 0
Hello there

I Agree with Ricky

Formulas don't remove duplicates !!!

Regards

Andreas
 
Upvote 0
It doesn't remove duplicates from the existing list. It removes duplicates from the new list that it creates. It works, trust me.
 
Upvote 0
Zacemmel,

which cell would this start in ?

and which range would have the potential list of duplicates ?

I was just trying to test this impressive formula but couldn't quite get the right ranges

thanks
Chris
:)
 
Upvote 0
Hello Zacemmel

I would like more details on this formula please.
:)

Andreas
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

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