| 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 | |||
Linear Mode
