Re: $$Excel-Macros$$ any short key to remove double add.

2011-09-02 Thread XLS S
Hey Kannan, please find the below link http://office.microsoft.com/en-us/excel-help/delete-duplicate-rows-from-a-list-in-excel-HA001034626.aspx On Tue, Aug 30, 2011 at 5:57 PM, kannan excel kannan.ex...@gmail.comwrote: Hi NOORAIN ANSARI, Pls tell wat is this.?? if you feel free explain

Re: $$Excel-Macros$$ any short key to remove double add.

2011-08-30 Thread kannan excel
Hi NOORAIN ANSARI, Pls tell wat is this.?? if you feel free explain me. Regards V. Kannan Aircel Limited Chennai On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Anil, Use Alt+A Q for Advance filter.. Choose *Filter the list-List range-Criteria

Re: $$Excel-Macros$$ any short key to remove double add.

2011-08-30 Thread Venkat CV
Hi Kannan, In Excel 2007(or)2010 version Having Advanced filter option you can get a unique records by using *Filter the list-List range-Criteria range-Unique Records only * * * *This Option will be used for removing duplicates and unique records viewing Purpuse..* *Best Regards,* *Venkat *

Re: $$Excel-Macros$$ any short key to remove double add.

2011-08-29 Thread NOORAIN ANSARI
Dear Anil, Use Alt+A Q for Advance filter.. Choose *Filter the list-List range-Criteria range-Unique Records only * On Mon, Aug 29, 2011 at 3:06 PM, anil kumar kmr7a...@gmail.com wrote: Dear all, I am attach. file in this file has some add. and some add. are is double, triple, so when i