Hi steve,
can u upload sum file for reference
Thanks,
Pavithra
On Thu, Dec 17, 2009 at 1:14 PM, Steve wrote:
> I have a few lists of names and dobs, each over 1,000 lines. I am
> trying to find names and dob's that are common to two lists. The
> names I want to pull out are the ones that are
Dear Steve,
It would be better if you can post the lists here so that we all can better
understand your needs / present situation.
Are Names there in a single column OR they are distributed as per First
Name, Middle Name, Last Name, .etc ?
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR
Option Explicit
'''IN SHEET1 FROM C1 RANGE U CAN PUT THE VALUE
DISTINCT VALUE CAN BE SEEN IN SHEET3 A1 RANGE
'
'
Sub MergeDistinct()
Hi Steve,
Please find attached excel for solution to your query.
I have use conditional formatting to find duplicate values in the lists.
Following is formula:
=COUNTIF(D3:D18, B3)>=1
I have applied conditional formatting for list 1. If name is there in both
the list then it will highlight that
Hey Steve,
Looks like your problem can be solved by using simple vlookup. Can you
please provide an example sheet so that I can put in the solution... (Sorry,
no time out of office work to create the example sheet myself)
Cheers!!
ANISH
On Thu, Dec 17, 2009 at 1:14 PM, Steve wrote:
> I have a
Sheet2!B:E,4,FALSE))
How's that?
Paul
____________
From: Steve
To: MS EXCEL AND VBA MACROS
Sent: Thu, December 17, 2009 2:44:10 AM
Subject: $$Excel-Macros$$ identifying duplicates
I have a few lists of names and dobs, each over 1,000 lines. I am
trying to find names a
I have a few lists of names and dobs, each over 1,000 lines. I am
trying to find names and dob's that are common to two lists. The
names I want to pull out are the ones that are on each, if they are
only on one list I am not interested in them.
What I've done so far is paste two lists together,
