Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 6th 05, 09:37 PM
JimNC
 
Posts: n/a
Default How do I find duplicates in a list

How do I find duplicates in a list that changes weekly. I want the adjacent
column to indicate an error if the column value is duplicated else where in
the list.

  #2   Report Post  
Old February 6th 05, 09:40 PM
Chip Pearson
 
Posts: n/a
Default

Jim,

See www.cpearson.com/excel/duplicat.htm for some example code and
formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JimNC" wrote in message
...
How do I find duplicates in a list that changes weekly. I want
the adjacent
column to indicate an error if the column value is duplicated
else where in
the list.





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
How do I find data from a list (or table) and insert it in a row? Bobgolfs56 Excel Discussion (Misc queries) 1 February 3rd 05 01:51 AM
Find a duplicate value within a list? Arla M Excel Worksheet Functions 2 January 26th 05 11:04 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 09:32 PM
Find duplicates R. Choate Excel Discussion (Misc queries) 5 November 28th 04 11:14 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 08:10 PM


All times are GMT +1. The time now is 02:53 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017