Prev: IF statement that yields a value based on a formula
Next: Autofill data based on an assigned code/prefix
From: DAY on 11 Feb 2010 12:17
I have 2 spreadsheets within the same workbook that contains duplicate
addresses. I need a macro or a formula to compare all of the addresses in a
column with other addresses within that same column and the same column in
the other worksheet to pull out duplicates over both worksheets.
Any ideas?
From: Eduardo on 11 Feb 2010 12:55
Hi,
Look into CPearson web

http://www.cpearson.com/excel/ListFunctions.aspx

2nd title = Extracting Elements Common To Two Lists

if this helps please click yes thanks

"DAY" wrote:

> I have 2 spreadsheets within the same workbook that contains duplicate
> addresses. I need a macro or a formula to compare all of the addresses in a
> column with other addresses within that same column and the same column in
> the other worksheet to pull out duplicates over both worksheets.
> Any ideas?
From: Ashish Mathur on 12 Feb 2010 19:32
Hi,

Could you give an example of data layout and expected result

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"DAY" <DAY(a)discussions.microsoft.com> wrote in message
news:E78AED84-F10B-4974-B427-3E2AC285A293(a)microsoft.com...
> I have 2 spreadsheets within the same workbook that contains duplicate
> addresses. I need a macro or a formula to compare all of the addresses in
> a
> column with other addresses within that same column and the same column in
> the other worksheet to pull out duplicates over both worksheets.
> Any ideas?

 | 
Pages: 1
Prev: IF statement that yields a value based on a formula
Next: Autofill data based on an assigned code/prefix