#1   Report Post  
Posted to microsoft.public.excel.misc
gwc gwc is offline
external usenet poster
 
Posts: 62
Default Delete cells

How can I delete the cells in Col B if their left 16 characters do
not
match the cells in Col A?

a b
000000006-6 1967 000000002-2 1957 0017731
000000006-6 1968 000000002-2 2002 0235432
000000012-1 1996 000000003-3 1957 0017043
000000034-1 1991 000000003-3 2002 0235433
000000048-4 1994 000000003-3 2003 0254130
000000048-4 1995 000000004-4 2002 0235434
000000048-4 1996 000000005-5 2002 0235435
000000048-4 1997 000000005-5 2003 0254131
000000059-4 1982 000000006-6 1967 0008339
000000059-4 1983 000000006-6 1968 0006437
000000059-4 1984 000000006-6 2002 0235436
000000059-4 1990 000000008-8 1963 0017131
000000059-4 1991 000000010-9 2002 0235437
000000063-7 1993 000000012-1 1996 0149047
000000063-7 1995 000000014-3 2002 0235438
000000063-7 1996 000000015-4 2002 0235439
000000063-7 1997 000000016-5 2002 0235440
000000034-1 1991 0101141
000000040-6 1961 0003885
000000043-9 1978 0034376
000000048-4 1994 0122266
000000048-4 1995 0135082
000000048-4 1996 0149048
000000048-4 1997 0161502
000000048-4 1998 0175210
000000048-4 1999 0186927
000000048-4 2000 0197851
000000048-4 2002 0235441
000000048-4 2008 0355864
000000048-4 2009 0372791
000000048-4 2010 0385805
000000048-4 2011 0398314
000000049-5 1959 0017982
000000051-6 1958 0016884
000000059-4 1982 0049201
000000059-4 1983 0054814
000000059-4 1984 0059644
000000059-4 1990 0094340
000000059-4 1991 0102782
000000061-5 1962 0017524
000000063-7 1993 0114767
000000063-7 1995 0135083


Reply
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
delete cells column. Delete empty cells myshak Excel Worksheet Functions 0 March 9th 09 10:59 PM
how do I merge cells into one then delete the original cells? LLR Excel Worksheet Functions 2 March 7th 08 10:59 PM
How to delete all the blanc cells in a worksheet and shift cells l tiramisu Excel Discussion (Misc queries) 2 December 7th 06 03:45 AM
macro to select cells containing specific text and delete all cells but these JenIT Excel Programming 3 March 27th 06 10:07 PM
Delete specific cells contents in a row with some locked cells in the same row trussman Excel Programming 2 March 1st 05 06:12 PM


All times are GMT +1. The time now is 03:01 PM.

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

About Us

"It's about Microsoft Excel"