Re: $$Excel-Macros$$ Required Unique data with funtion

2012-11-08 Thread Eugene Bernard
Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On

Re: $$Excel-Macros$$ Required Unique data with funtion

2012-11-08 Thread Kuldeep Singh
Sure Priyanka, First Sort data then use formula. It's working fine. Regards, Kuldeep Singh On Fri, Nov 9, 2012 at 11:52 AM, Eugene Bernard eugene.bern...@gmail.comwrote: Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM,

Re: $$Excel-Macros$$ Required Unique data with funtion

2012-11-08 Thread Eugene Bernard
How to achieve this thro' functions without manually sorting. Regards Eugene On Fri, Nov 9, 2012 at 11:56 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Sure Priyanka, First Sort data then use formula. It's working fine. Regards, Kuldeep Singh On Fri, Nov 9, 2012 at 11:52 AM, Eugene

$$Excel-Macros$$ Required Unique data with funtion

2012-10-30 Thread Priyanka Vaish
Hi Experts, Please solve this Query. Regards, Priyanka -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Required Unique data with funtion

2012-10-30 Thread Kuldeep Singh
Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish vaishpriyanka2...@gmail.com wrote: Hi Experts, Please solve this Query. Regards, Priyanka -- Join official

Re: $$Excel-Macros$$ Required Unique data with funtion

2012-10-30 Thread Priyanka Vaish
Hi Kuldeep, Thank a lot. Regards, Priyanka On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On Tue, Oct 30, 2012 at 11:47 AM,

Re: $$Excel-Macros$$ Required Unique data with funtion

2012-10-30 Thread Priyanka Vaish
: Re: $$Excel-Macros$$ Required Unique data with funtion To: excel-macros@googlegroups.com Hi, u can also try this: 1 . Go to the advanced auto filter in Excel 2007/2010 2. Go to the Data tab and select Advanced from the Sort Filter section. 3. To copy the list in place leave everything

Re: $$Excel-Macros$$ Required Unique data with funtion

2012-10-30 Thread RAJA SEKAR
* *Pravin Gunjal.* -- Forwarded message -- From: Rohan Young rohan.j...@gmail.com Date: Tue, Oct 30, 2012 at 12:59 PM Subject: Re: $$Excel-Macros$$ Required Unique data with funtion To: excel-macros@googlegroups.com Hi, u can also try this: 1 . Go to the advanced auto