Delete Row If Doesn't Contain Certain Numbers
Jan 18, 2008
Working at a company where we every month extract our customers into a excel document.
This is the CRM system , and some of the clients can't (shouldn't) be approached.
In Cell C is their customer classifications. In total there is about 60 different classifications. 10 of them is clients who we can send information to. For example customers with class 11111 or 41414 or 51515 or 61616 (among with 45 others) can't be approached. I'd like a macro/script who can delete all the nonrelevant clients so that afterwards I have a list of clients who can be approached.
View 9 Replies
ADVERTISEMENT
Jan 22, 2014
See the excel sheet [URL]
I need to delete all the digits before / and also the / - in the valuta columns. But this =RIGHT(B2,LEN(B2)-6) doesnt work It says > the formula you typed contains an error
View 14 Replies
View Related
Oct 27, 2008
I'd like to tell Excel that anytime it finds the text "ABC" anywhere in any cell in column B but doesn't have any data in column A, to delete the entire row.
View 6 Replies
View Related
Jun 10, 2008
In the attached sheet, i would want to delete the text "ABC" because it is not contained anywhere in column A.
Couldnt find a macro on here for this...
View 6 Replies
View Related
Apr 14, 2014
I have worksheet that contains the wording "Total For Page" in columns A:N. I would like to find that wording delete that row and 3 rows below it. found the code below that works, but I have to continually run it to find the wording and delete the rows. The code doesn't search all and delete in one shot.
[Code]....
View 3 Replies
View Related
Mar 18, 2014
I have a macro below where it looks at sheets name and deletes if Jan is not there.
I would like to change this a bit so that it looks for all 12 months (Jan to Dec) instead of looking for Jan only.
View 8 Replies
View Related
Jun 20, 2007
Sub DeleteRowsBasedOnCriteria()
'Assumes the list has a heading.
Dim cl As Range
For Each cl In Range("A6", Range("A65536").End(xlUp))
If cl.Value <> "=~*" Then
cl.EntireRow.Delete
End If
Next cl
End Sub
but it is deleting every row, I am not sure what is wrong?
starting in cell A6
if cell does not start with *, then
delete entire row,
next cell
that is the logic im seeing...ive tried a few o ther combinations like "~*" etc...
View 9 Replies
View Related
Jun 2, 2009
I have a column of cells (Column I2:I1063) with zip codes in it and I want to keep the row if the zip code matches one on the list in a column B2:B100 on a separate sheet (Sheet1).
View 4 Replies
View Related
Oct 24, 2011
Code below. I need it to NOT run if the sheet week2 doesn't exist. Currently it gives a runtime error '9' out of range. This is due tot he sheet not being present because sometimes it is not generated.
Code:
Sub RemoveColWeek2sheet()
Dim ColNo As Integer
Dim rng As Range
Set rng = ThisWorkbook.Sheets("Week2").UsedRange
[Code] .........
View 6 Replies
View Related
Feb 12, 2010
Is it possible to delete a column of numbers then replace those numbers from adjacent columns and the adjacent columns are then filled with the numbers adjacent to them
View 9 Replies
View Related
Mar 14, 2008
I want to ask that I have got a workbook with different number series i want user form where i can enter its start number and end number and then it finds and delete shift cells up said series number i have entered in user form please see mentioned below example.
Series
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
and i want to delete 1 to 5 numbers delete to shift cells up.
View 9 Replies
View Related
Aug 16, 2007
I have a sheet in Excel 2004 for Mac that is a patient list with over 2000 patients. I need a rule that will compare values (patient IDs and responsible party ID) in two adjacent cells, if the values are different, to delete the entire row. The goal is to get rid of patients (rows) that are not the responsible party (responsible party ID).
View 3 Replies
View Related
Jun 24, 2007
How is it possible to delete the phone numbers which include 39 like (323940, 393312, 124039, and so) suppose all the phone numbers are in cell B
View 9 Replies
View Related
Dec 14, 2008
Is there a way to delete only numbers ending in a decimal from a column of numbers? I have a column of numbers but only the non decimals are relevant to the next equation.
View 3 Replies
View Related
Feb 15, 2009
I have attached a pdf of part of my data. I wish to delete those cells in column 2 containing values between 9044795 and 9372402; then have the column below move up (into the cell deleted). Its a large data set so doing it manually is not an option.
After doing this the data across the rows should line up. I have tried using the replace and filter functions but I can't make it work. I've tried some VBA but my knowledge is wanting.
View 4 Replies
View Related
Dec 10, 2012
is there anyway i can delete all numbers from a column, leaving only alpha characters?
View 8 Replies
View Related
Sep 23, 2013
I have 50,000 to 150,000 rows of data. Row M has data from 0001 to 9999. I need to delete all rows except the rows with values 2500 to 4999. I had this working with a similar and smaller spreadsheet awhile back using an advanced filter. In this case I need to delete the unneeded rows. I would imagine I could also achieve it with a VLOOKUP array and a lot of finagling but with this many records to repetitively
View 8 Replies
View Related
Oct 13, 2007
I have a unique 6 digit number in a column. I have 2500 rows. I need to cut the first three numbers only leaving the last 3 numbers in the column for each row.
Example:
112345
234325
I would need 112, and 234 deleted. Checked the forum and cannot get quite what I want.
View 9 Replies
View Related
Dec 20, 2007
I'm looking for a way, inside a Macro, to delete any value in a range of cells that is not a whole number.
Say I have a range from "A4:C50" I am pasting items from another sheet through a Macro Button but I want code at the end of the Macro to then delete anything in this range that is not a whole number.
View 3 Replies
View Related
Feb 3, 2014
I need to find the minimum of 4 numbers placed in 4 columns and delete the one which is minimum among them. I know to find minimum I can use min function but i don't know after finding how can i delete that automatically. Also problem is if two or more numbers are identical and minimum value it has to delete any one of them.
View 4 Replies
View Related
Mar 3, 2014
column "b" in the attached file has numbers that match some numbers in column "c" I need to delete all the rows that done match the numbers in column "c" that are used in column "b"
for example no " 53" is in column "c" but not column "b" so they need deleting
View 7 Replies
View Related
Sep 28, 2009
I need to delete all characters BUT numbers (including decimals) in my sheet. Does anyone know how I can do this? I can do it either by using the find/replace menu, or use vba.
View 6 Replies
View Related
Aug 15, 2007
I need to know how I can delete NUMBERS in front of the names....
I.E.
Colume B
12Smith
12John
13Chris
152Matt
1111Joe
12569Joe
1234Smith
I need to delete the numbers in front of the names - i have about 26thousand records like this and need to know how i can delete them.
View 9 Replies
View Related
Jul 22, 2008
I already have a few macros I run in order to sort data. I am able to show problem data by using a macro to perform an output that puts the number "1" in a cell if there is a problem.
I'm looking for some help if someone could create/show me a macro that can delete stacked numbers. For this I mean if there is the number "1" in cell A1 and a "1" in cell A2, I want to delete the bottom of the two which means remove the "1" in cell A2 so that there are no 1's that are stacked. The number "1" in cell A1 and a number "1" in cell A3 is fine.
View 9 Replies
View Related
Mar 17, 2007
I have inserted a set of numbers from the web, and some are appearing with $, and others with commas, and also some with spaces before the numbers. I can remove the $ and commas fine using crtl replace but cant get rid of the spaces before the numbers? I seem to remember in word there is a way to do this using crt+replace (using $ or ^ sign perhaps?) but need my memory jogged.
View 5 Replies
View Related
Apr 29, 2008
For the description below I will be referring to the file I have attached.
I would like to write a VBA macro which will look at columns 1-4, if ALL of these are blank it will take the results from the row below in their place.
So the code column on the left will be displayed next to columns 1-4 in the row below, if columns 1-4 adjacent to the code are blank.
The 'Raw Data' columns show how the raw data will be fed into the spreadsheet.
The 'Output' columns show the desired output I would like from the raw data columns.
View 9 Replies
View Related
Apr 22, 2014
I've got a spreadsheet that's basically a large list of numbers, both whole and decimal. For example, let's say this is in cells A1-A5:
4
0.65
1.34
3
8.2
Is there a formula to get rid of all of the whole numbers but leave the decimals? (What I mean by that is I don't need 4 or 3 as they're whole, but I need the decimals to be left alone).
I know it's probably a really awkward question but I have over 2,000 lines to go through, it will take a long time to do manually.
Perhaps if it's not possible to a formula to delete entries, maybe just make all whole numbers say something like "NO", so that I can sort the column in A-Z order and delete all of the 'NO's quickly by highlighting them all together.
View 5 Replies
View Related
Dec 23, 2009
I am trying to use the code below to eliminate data in a spreadsheet based on certain criteria. I have been able to get this to work with text fields just fine, but now I am running into an issue with numbers. I am trying to get this code to delete rows if they have the word "unknown" in column C and if the value in column B is greater than 900 hours (999:00:00), the numbers in this column are formatted as [hhh]:mm:ss. What should I tweak to make this work?
View 7 Replies
View Related
Jun 23, 2008
I need to remove multiple instances of pages numbers from a 2000 character text string I have dumped into a cell. The spacing is not equal between the page numbers but they always take the form |#####-##| i.e. bar delimited 5 digit-2 digit. I tried SUBSTITUTE but it will not accept wildcards. I was thinking of looping through a SEARCH. The numbers are ordered ie |00001-01| to |00001-25| then |00002-01| etc, stopping at 25. This might lend to looping but I couldn't wrap my head around the VBA to accomplish that. A sample of the text
"|00006-01| (Defendants' Exhibit Nos. 1,2 marked for |00006-02| Identification.) |00006-03| BY MR. JOHNSON: |00006-04| Q. Doctor, I am handing you Exhibits 1 and 2. |00006-05| Exhibit 2, is that the one that you brought with you, |00006-06| the deposition notice of today? |00006-07| A. I believe so, yes." Auto Merged Post Until 24 Hrs Passes;I should have said this before but this is for use on Excel 2003 WinXP.
View 8 Replies
View Related
Jun 25, 2008
i m creating a macro to delete extra characters in a column. I have over 200,000.00 records in one column which consists of numbers with characters. For example:
#80723666
-80726960
80730187--
/ 80730279
80736277 /
( )80739210
* 80739823
& 80735380
80796440 @
## 80722138
if anybody can come up with a macro, so that I can just have the numbers and nothing else. I would like to exclude the following -~!@#$%^&*()_=+?/.";:|][{},^` within a cell.
View 4 Replies
View Related
