ExcelBanter - 2 Spreadsheets find duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - 2 Spreadsheets find duplicates (https://www.excelbanter.com/excel-worksheet-functions/247097-2-spreadsheets-find-duplicates.html)

marsue1995

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.

Peo Sjoblom[_3_]

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.

Peo Sjoblom[_3_]

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.

Teethless mama

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.

All times are GMT +1. The time now is 03:43 AM.