Hi,
Please try this macro. This macro will give reference of numbers that matches
in D column
i have inserted two columns in bwtween) with col A and also "true" and also a
ref of A column
next to D column. Confirm actualy what u want.(i have added 4or 6 numbers for
examble)
--R.Karunanithi
Sub
Try this
=IF(ISERROR(VLOOKUP(B2,A:A,1,0)),"Common","Double")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of HARI NAIR
Sent: Wednesday, July 06, 2011 10:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ marco to find common value
I
I want common numbers of both column should shown in column C while
clicking a button. I have used the following formula, but it take very
long time to process each time I opened the file. Thanks
=INDEX($A$2:$A$1642,SMALL(IF(COUNTIF($B$2:$B$1642,$A$2:$A$1642),ROW($A$2:$A$1642)-MIN(ROW($A$2:$A$
Pls find the attached
This function will give you only the common values in both the columns
On Wed, Jul 6, 2011 at 10:49 AM, HARI NAIR wrote:
> I want a marco to find common values of column A and B in column C in the
> attached file. Please Help.
>
> --
> ---
check the attachment
On Wed, Jul 6, 2011 at 10:49 AM, HARI NAIR wrote:
> I want a marco to find common values of column A and B in column C in the
> attached file. Please Help.
>
> --
>
> --
> Some important links f
