#1   Report Post  
T De Villiers
 
Posts: n/a
Default Duplicates


Hi,

I have a column Of Numbers and would like to create a worksheet
function
which identifies duplicates,

help on this is much appreciated

T


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=399027

  #2   Report Post  
dominicb
 
Posts: n/a
Default


Good afternoon T De Villiers

Chip Pearson's pages provide quite a bit of information about dealing
with, identifying and tagging duplicates - particularly by using
existing functions and avoiding VBA or UDFs. Suggest this is your
first stop.

http://www.cpearson.com/excel/duplicat.htm

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=399027

  #3   Report Post  
T De Villiers
 
Posts: n/a
Default


Thanks a lot Dominic


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=399027

  #4   Report Post  
dominicb
 
Posts: n/a
Default


Hi T

You're welcome. Appreciate the feedback.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=399027

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Marking Duplicates Daniell Excel Worksheet Functions 1 May 26th 05 10:53 PM
Duplicates bj Excel Discussion (Misc queries) 0 May 20th 05 07:21 PM
Find and mark duplicates maxtrixx Excel Discussion (Misc queries) 3 May 6th 05 02:13 AM
Finding Duplicates nospaminlich Excel Worksheet Functions 4 February 5th 05 11:57 PM
Finding and Deleting duplicates in a column Brian Excel Worksheet Functions 3 February 5th 05 02:19 PM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"