Dear Neeraj, You can also use Data->Remove Duplicates in 2007 and Advance Filter to remove duplicate.
with formula you can use.......... =sumproduct(--($C$2:C2=c2)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> On Thu, Sep 29, 2011 at 1:02 PM, Neeraj Chauhan <neerajchauhan...@gmail.com>wrote: > Dear Experts,**** > > ** ** > > I have a data, which have duplicate Indus id but each Indus id has a unique > date, I want to know how can I put the Indus id of the last date. And want > to remove the another Indus id.**** > > Kindly find the data **** > > ** ** > > ** ** > > ** ** > > *Thanks & Regards* > > *Neeraj Chauhan* > > *MIS Executive.* > > *b4S* *Solutions (P) Ltd.***** > > *169/1 Mangal Pandey Nagar***** > > *Meerut UPW 2500001***** > > *Mob. +91-**9756706882* > > *email-neerajchauhan...@gmail.com***** > > ** ** > > *From:* Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] > *Sent:* Thursday, September 29, 2011 11:47 AM > *To:* 'excel-macros@googlegroups.com' > *Subject:* How to remove the duplicate value**** > > ** ** > > Dear Experts,**** > > ** ** > > I have a data, which have duplicate Indus id but each Indus id has a unique > date, I want to know how can I put the Indus id of the last date. And want > to remove the another Indus id.**** > > Kindly find the data **** > > ** ** > > ** ** > > ** ** > > *Thanks & Regards* > > *Neeraj Chauhan* > > *email-neerajchauhan...@gmail.com***** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
