Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-12 Thread bpascal123
Tell me please how can an excel formula add rows ? -- -- 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://

Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-12 Thread rajan verma
use this in Column C:C =IFERROR(VLOOKUP(A1,B:B,1,0),"") Rajan. On Sat, Mar 12, 2011 at 3:42 PM, Sanjoy Nath wrote: > no need to write macro > sort any one column > and use lookup to other column > that will work fine > > > > On Sat, Mar 12, 2011 at 6:06 AM, bpascal123 wrote: > >> Hi cyberspace,

Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-12 Thread Sanjoy Nath
no need to write macro sort any one column and use lookup to other column that will work fine On Sat, Mar 12, 2011 at 6:06 AM, bpascal123 wrote: > Hi cyberspace, > > I have spent quite some time trying to make this work but at this > point from adding many msgbox checks, using the watch window

$$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-11 Thread bpascal123
Hi cyberspace, I have spent quite some time trying to make this work but at this point from adding many msgbox checks, using the watch window for variables values everything seems coherent to me. I have 2 columns with sorted identical and not identical numercial values in both columns, see belo