Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
I have a spreadsheet with a title row ("A1 to G1"). Below the title row is a range of data which currently resides in ("A2 to G41444"). Column 6 is titled "Centre Number" and is made up of a column of numbers, some with numbers and letters (see sample data below). What I need to do is test this column and delete any row within the spreadsheet that does not have one of the numbers below in column 6. There are 59 different numbers to be tested. I am hoping to have this automated as the number of rows will vary. Any ideas would be welcomed. If this is not clear or you need additional info, let me know. Thanks.
001045
002145
039283
001053
048302
048944
048945
048946
014119
002248
059010
020111
010089
020089
002305
037430
055322
001903
002272
044950
000933
048217
010119
002411
042255
002377
041244 G6
041244
052324
726492
072132
049932
002235
001090
002126
001057
005133
020104H
020104
020104D
020239
025288
058653
020250
030405
002116
058621
039106
044325
032135
021902
001088
000837
019311
050645
035219
000602
001026
001963
001045
002145
039283
001053
048302
048944
048945
048946
014119
002248
059010
020111
010089
020089
002305
037430
055322
001903
002272
044950
000933
048217
010119
002411
042255
002377
041244 G6
041244
052324
726492
072132
049932
002235
001090
002126
001057
005133
020104H
020104
020104D
020239
025288
058653
020250
030405
002116
058621
039106
044325
032135
021902
001088
000837
019311
050645
035219
000602
001026
001963