Counting duplicate values
bump
Hello friends,
I'm trying to find a code that will count duplicate values in columns B,C and D and put the outcomes in B1, C1 and D1.
If've tried conditional formatting but can't count any formatted cells with duplicate values.
Any Ideas?
Greetings,
Roberto, The Netherlands
Last edited by roberto1111; 11-21-2009 at 06:43 AM.
Use conditional formatting with Formula Is something like
=COUNTIF(range,criteria)>1
Hi there Teylyn,
Thank you for the suggestion but I'm really looking for a modification of the code I've posted.
..........
Last edited by roberto1111; 11-21-2009 at 06:44 AM.
..............
Try putting this in B2 and dragging right
=SUM(IF(FREQUENCY(B2:B11,B2:B11)>1,FREQUENCY(B2:B11,B2:B11)))
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Re: Counting duplicate values
Hello MikeRickson I fixed the problem with your advise.
Thank you very much.
Roberto
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks