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