10173a.jpg
10173b.jpg
10289a.jpg
10289b.jpg
10296a.jpg
10297a.jpg
I have 414 entries and wish to exclde cells ending with 'b'
help much appreciated
Robert
10173a.jpg
10173b.jpg
10289a.jpg
10289b.jpg
10296a.jpg
10297a.jpg
I have 414 entries and wish to exclde cells ending with 'b'
help much appreciated
Robert
Filter the column > then Custom filter > contains b and delete rows
or a formula. Say data in Col A enter this in Col B
VBA Noob=IF(ISERROR(SEARCH("b",A1)),A1,"")
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Many thanks the fomular worked fine.
May ask ow to now get rid of the empty cells in col. b as I want to count rows
cheers Robert
Use the filter option then
or use this and filter on False and delete
VBA Noob=ISERROR(SEARCH("b",A1))
Many thanks
Goodnight from UK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks