rehan.azher
12-02-2008, 02:48 AM
Dear Experts,
I am facing a problem to extract unique rows from the a sheet. My sheet have four columns as below.
EQX-A 08 SLD64 01
SGP-B 08 SLD64 01
SGP-B 08 SLD64 01
JKT-B 07 SL64 01
EQX-A 08 SLD64 02
now i want to get unique rows from the above as below
EQX-A 08 SLD64 01 SGP-B 08 SLD64 01 JKT-B 07 SL64 01 EQX-A 08 SLD64 02
Note: first and lost row have fourth column different. and 2nd , 3rd are completely identical to each other.
i want to copy the result to another sheet.
any help for this in VBA
I am facing a problem to extract unique rows from the a sheet. My sheet have four columns as below.
EQX-A 08 SLD64 01
SGP-B 08 SLD64 01
SGP-B 08 SLD64 01
JKT-B 07 SL64 01
EQX-A 08 SLD64 02
now i want to get unique rows from the above as below
EQX-A 08 SLD64 01 SGP-B 08 SLD64 01 JKT-B 07 SL64 01 EQX-A 08 SLD64 02
Note: first and lost row have fourth column different. and 2nd , 3rd are completely identical to each other.
i want to copy the result to another sheet.
any help for this in VBA