| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find all same numbers in a column without dropdown listing
Trying to find all alike numbers in a column of about 5000. Data is sorted
by number already but the list it to long to look through. Filtering the data only brings up another long list to have to go through. Is there a formula that will find them and highlight them? There could be numerous different ones. Example 001-3456 001-3456 001-7890 001-7890 002-9876 002-9876 002-9787 Find all alike Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find all same numbers in a column without dropdown listing
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx ShoDan wrote: Trying to find all alike numbers in a column of about 5000. Data is sorted by number already but the list it to long to look through. Filtering the data only brings up another long list to have to go through. Is there a formula that will find them and highlight them? There could be numerous different ones. Example 001-3456 001-3456 001-7890 001-7890 002-9876 002-9876 002-9787 Find all alike Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find all same numbers in a column without dropdown listing
I think you can use countif in conditional formatting.
If your list is in column A. Select A1 and set the conditional format Formula Is: =COUNTIF($A$1:$A$5000,A1)1 and pick the color you want. Copy A1 and pastespecial / formats from A1 thru A5000. "ShoDan" wrote in message ... Trying to find all alike numbers in a column of about 5000. Data is sorted by number already but the list it to long to look through. Filtering the data only brings up another long list to have to go through. Is there a formula that will find them and highlight them? There could be numerous different ones. Example 001-3456 001-3456 001-7890 001-7890 002-9876 002-9876 002-9787 Find all alike Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find all same numbers in a column without dropdown listing
Check out Jim Cone's fine commercial Add-in called "XLCompanion".........it's
available at: http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "ShoDan" wrote: Trying to find all alike numbers in a column of about 5000. Data is sorted by number already but the list it to long to look through. Filtering the data only brings up another long list to have to go through. Is there a formula that will find them and highlight them? There could be numerous different ones. Example 001-3456 001-3456 001-7890 001-7890 002-9876 002-9876 002-9787 Find all alike Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where can I find a listing of characters using alt keys | Excel Worksheet Functions | |||
| Listing of cell references from a FIND All command. | Excel Discussion (Misc queries) | |||
| How to find duplicate data in two tables,then listing it? | Excel Worksheet Functions | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I need to find odd numbers in a column | Excel Worksheet Functions | |||
Hybrid Mode
