LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default Move cells down

If the left 11 characters in column E do not match the left 11
characters in column A, how can I move the cells in column E down
until they do match?

a b c
d e
001531594-8 2001 33 001531594-8 CF 5501 PM
001531594-8 2002 33 001531596-0 CF 4345 NN
001531594-8 2003 33 001531598-2 CF 5500 PM
001531594-8 2004 33 001531602-2 CF 4455 PK
001531596-0 2011 33 001531609-9 CF 6898 SB
001531598-2 2004 33 001531611-0 CF 6888 PG
001531602-2 2009 33 001531622-0 CF 6879 PG
001531602-2 2010 33 001531631-8 CF 4909 NR
001531602-2 2011 33 001531645-1 CF 5451 PL
001531609-9 2006 33 001531650-5 CF 7174 PJ
001531611-0 2005 33 001531653-8 CF 5438 PL


Here are the results I'm looking for:

a b c
d e
001531594-8 2001 33 001531594-8 CF 5501 PM
001531594-8 2002 33
001531594-8 2003 33
001531594-8 2004 33
001531596-0 2011 33 001531596-0 CF 4345 NN
001531598-2 2004 33 001531598-2 CF 5500 PM
001531602-2 2009 33 001531602-2 CF 4455 PK
001531602-2 2010 33
001531602-2 2011 33
001531609-9 2006 33 001531609-9 CF 6898 SB
001531611-0 2005 33 001531611-0 CF 6888 PG
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search for empty cells and move cells next to KP[_4_] Excel Programming 10 September 21st 11 08:44 PM
Move cells down to match cells gcotterl[_2_] Excel Programming 3 April 1st 10 06:54 PM
Move cells down to match cells gcotterl[_2_] Excel Programming 0 March 31st 10 10:34 PM
Can references (to cells being sorted) move with the cells? Zack Setting up and Configuration of Excel 1 January 16th 08 01:50 PM
Sorting cells: a list behind the cells do not move with the cell Ross M Excel Discussion (Misc queries) 2 September 21st 06 12:14 PM


All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"