| Home |
| Search |
| Today's Posts |
|
#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! |
| 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 | |||
Threaded Mode
