uot; & i
End If
Next j
Next i
End Sub
--- On Wed, 7/6/11, HARI NAIR wrote:
From: HARI NAIR
Subject: $$Excel-Macros$$ marco to find common value
To: excel-macros@googlegroups.com
Date: Wednesday, July 6, 2011, 10:49 AM
I want a marco to find common values of column A and
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
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
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 for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
