If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleting rows contains certain text in column A
In Sheet1, I have A1:H2619. In Sheet2 I have something in A1:A997. The text
in column A of Sheet1 and the text in column A of Sheet2 or similar, but just column A, Sheet1 I has a bigger database (2619 cells), while in column A of Sheet2 I just have 997 cells. I want to delete all the rows in Sheet1, if in column A of that row, we find the exact match in one of the cells of Column A, Sheet2. For example. Column A sheet 1 may contain Jan, Feb, Mar, Apr, May, June. While Column A in Sheet2 only has Feb, Apr. So I want to delete the rows in Sheet1 which contains Feb, and Apr. in column A. Is there any formula or code could do this. I appreciated your help. |
#2
|
|||
|
|||
I found one solution by myself
Use countif function (let's say, in column K of sheet1, and return some numbers (0, 1, 2 or 3) Then sort the database by column K. Then delete the rows with 1,2 or 3 in column K. "plumstone" wrote: In Sheet1, I have A1:H2619. In Sheet2 I have something in A1:A997. The text in column A of Sheet1 and the text in column A of Sheet2 or similar, but just column A, Sheet1 I has a bigger database (2619 cells), while in column A of Sheet2 I just have 997 cells. I want to delete all the rows in Sheet1, if in column A of that row, we find the exact match in one of the cells of Column A, Sheet2. For example. Column A sheet 1 may contain Jan, Feb, Mar, Apr, May, June. While Column A in Sheet2 only has Feb, Apr. So I want to delete the rows in Sheet1 which contains Feb, and Apr. in column A. Is there any formula or code could do this. I appreciated your help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
converting column of text to text box for repetitive records | bilboda - ExcelForums.com | General Discussion | 3 | September 15th, 2004 12:48 AM |
Column to Text Question - Stop after one break | Sole Admiral | General Discussion | 1 | August 21st, 2004 02:31 AM |
Format a manual to print a narrow column of flowing text on right | Barbinca | Page Layout | 1 | August 9th, 2004 12:13 AM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |
Deleting Empty Rows | Frank Kabel | Worksheet Functions | 1 | March 15th, 2004 10:16 AM |