VBA to Get unique records from a range

[Manish Jha]

Extract unique record from a range

sheet 1 (Master Data)

Model	CRTM No
LCV	12TREFX601
LCV	12TREFX602
LCV	12TREFX603
LCV	12TREFX604
LCV	12TREFX605
LCV	12TREFX606
LCV	12TREFX607
LCV	12TREFX608
ICV/MCV	12TREDN626
ICV/MCV	12TREDN627
ICV/MCV	12TREDN628
ICV/MCV	12TREDN629
ICV/MCV	12TREDN630
ICV/MCV	12TREDN631
ICV/MCV	12TREDN632
ICV/MCV	12TREDN633
HCV	12TREDD839
HCV	12TREDD840
HCV	12TREDD841
HCV	12TREDD842
HCV	12TREDD843
HCV	12TREDD844

Get Data in sheet 2 from sheet 1 (There should be no duplicate CRTM No) only unique value needs to be extracted . Extra column can be added if require

LOB	CRTM No
LCV
LCV
LCV
ICV/MCV
LCV
ICV/MCV
HCV
HCV
HCV

 

[vletm]

Manish Jha
Avoid to duplicate Your thread.
Use Your original which has moved to correct Forum.

Vlookup or Match index to get Unique Record

Please help in VBA code, need to get unique record through VBA code .

chandoo.org

This thread is closed now.