Hi hamal,
Use can use filter if it help to you…….
Ctrl+Shift+L -> drop filter -> *filter by color* -> *filter by cell
color *-> Press
enter.
Regards,
Brajesh
On Wed, Sep 28, 2011 at 5:39 PM, hemal shah wrote:
> If you have excel 2007 then follow the following procedure
>
> Select the your
If you have excel 2007 then follow the following procedure
Select the your data range and go to Home --> Conditional Formatting
-->Highlight Rules--> Duplicate Values..
It will highlight your duplicate data and by filtering it you can copy it.
Regards
Hemal
9260544391
--
