You could use this as your criteria but what happens if you also have the
same amount for another 100 rows down and you sort by col E. You could get
UN intended results.
-----Original Message-----
From: Gaetan M
Sent: Wednesday, August 31, 2011 7:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Macro to remove repeats and merge
ok thanks but I what i was wondering is if there is a possibility to
run a macro to remove the prior line and combine them. I have a large
amount of data and I need to compile it. So what i need to do is for
everytime 2 or more items in column E are the same, they are merged
and B2 takes the spot of B1.
Is this something that can be done?
Thanks
On Aug 30, 11:33 pm, Venkat CV <venkat1....@gmail.com> wrote:
Hi,
You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T
*Best Regards,*
*Venkat *
*Chennai*
On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M <gaetan.me...@wanadoo.fr> wrote:
> I have the following:
> Column A B C D
> E F
> 12722 12722 51.5 64.89 RNLO X
> 12723 12723 51.5 64.89 RNLO X
> Would you have the solution to replace B1 by B2 and delete row 2 once
> completed since they have been merge?
> Thanks,
> G.
> --
>
----------------------------------------------------------------------------------
> 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 athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://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
--
*
*
*
*
*
*- Hide quoted text -
- Show quoted text -
--
----------------------------------------------------------------------------------
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
