Unique Record retrieval.

[Aligahk06]

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

 

[Jacob Skaria]

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

 

[Bernd P]

Hello,

One possible solution:
http://sulprobil.com/html/pfreq.html

Regards,
Bernd