A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to find repetition of data in cells in a column?



 
 
Thread Tools Display Modes
  #1  
Old February 15th 06, 05:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default How to find repetition of data in cells in a column?

I have to check repetition of data in cells in a column. For eg. i want to
check if data in D3 cell is repeating in any cell other cell in D column
Ads
  #2  
Old February 15th 06, 06:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default How to find repetition of data in cells in a column?

Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm

Joseph T J wrote:
>
> I have to check repetition of data in cells in a column. For eg. i want to
> check if data in D3 cell is repeating in any cell other cell in D column


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I compare data in two worksheets to find matching cells? Gary Excel Discussion (Misc queries) 4 March 2nd 06 09:04 PM
How do I find the last instance of data in a column IJ Rosenblum Excel Worksheet Functions 1 February 1st 06 08:28 PM
Reference multiple cells in if statement PAR Excel Worksheet Functions 1 June 10th 05 06:28 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 04:05 AM.


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