Unique Record retrieval.
Try the below macro with the below data in ColA/B. Please note there is a
header assigned to these columns...The unique list will be generated in
ColD/E. If you are new to macros
--Set the Security level to low/medium in (Tools|Macro|Security).
--From workbook launch VBE using short-key Alt+F11.
--From menu 'Insert' a module and paste the below code.
--Get back to Workbook.
--Run macro from Tools|Macro|Run <selected macro()
Col A Col B
Header 1 Header 2
Rstyv 1"50 2.5
Rstyv 2"50 3.5
Rstyv 1"50 2.5
Rstyz 3"50 8.5
Rstyv 2"50 3.5
Sub Macro()
Columns("A:B").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("D1"), Unique:=True
End Sub
If this post helps click Yes
---------------
Jacob Skaria
"Aligahk06" wrote:
Dear All,
I want to fetch unique records through Formula or VBA.
I have two records in two different column.I want to fetch Unique records
from both the Column.
E.g
Col k10:k25 Col L10:L25
Rstyv 1"50 2.5
Rstyv 2"50 3.5
Rstyv 1"50 2.5
Rstyz 3"50 8.5
Rstyv 2"50 3.5
..........and so on.
i want to display in another two column the unique records from range
k10:k25 to corresponding
Col L10:L25.
Please assist,
Rgds,
aligahk06
|