| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 Spreadsheets find duplicates
I have 2 speadsheets policy numbers on them. I need to find the duplicates
from the smaller list and match it up to the larger list. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 Spreadsheets find duplicates
Here are some methods
-- Regards, Peo Sjoblom "marsue1995" wrote in message ... I have 2 speadsheets policy numbers on them. I need to find the duplicates from the smaller list and match it up to the larger list. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 Spreadsheets find duplicates
Sorry, here's the link :)
http://www.cpearson.com/excel/Duplicates.aspx -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... Here are some methods -- Regards, Peo Sjoblom "marsue1995" wrote in message ... I have 2 speadsheets policy numbers on them. I need to find the duplicates from the smaller list and match it up to the larger list. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 Spreadsheets find duplicates
=IF(COUNTIF(Sheet1!A:A,A1),"duplicate","")
"marsue1995" wrote: I have 2 speadsheets policy numbers on them. I need to find the duplicates from the smaller list and match it up to the larger list. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Duplicates | Excel Discussion (Misc queries) | |||
| find duplicates | Excel Worksheet Functions | |||
| How do I find (not delete) duplicates in multiple spreadsheets? | Excel Worksheet Functions | |||
| Find Duplicates | Excel Discussion (Misc queries) | |||
| How do I merge two spreadsheets so it removes the duplicates? | Excel Worksheet Functions | |||
Linear Mode
