Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find a duplicate value within a list?
I am trying to create a simple formula that finds and displays any duplicate
values in a list. I figured this should be easy to do, but I can't find anything that will perform this action for me! Help! |
#2
|
|||
|
|||
http://www.cpearson.com/excel/duplicat.htm
Regards, Peo Sjoblom "Arla M" wrote: I am trying to create a simple formula that finds and displays any duplicate values in a list. I figured this should be easy to do, but I can't find anything that will perform this action for me! Help! |
#3
|
|||
|
|||
In a Helper column, use this formula
=COUNTIF($A$1:$A$100,A1) Then Data/AutoFilter on that column to show rows with numbers 1. On Wed, 26 Jan 2005 12:47:05 -0800, Arla M <Arla wrote: I am trying to create a simple formula that finds and displays any duplicate values in a list. I figured this should be easy to do, but I can't find anything that will perform this action for me! Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
find duplicate cells in Excel | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions |