ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Duplicates (https://www.excelbanter.com/excel-worksheet-functions/42335-duplicates.html)

T De Villiers

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


dominicb


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


T De Villiers


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


dominicb


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



All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com