Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique Record retrieval.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique Record retrieval.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Unique Record | Excel Discussion (Misc queries) | |||
Find unique record | Excel Discussion (Misc queries) | |||
lots of data to be sorted for each unique record | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
Display unique record | Excel Discussion (Misc queries) |