remove rows

  1. J

    Remove Row if two cells are blank from a result on another sheet

    Hi all My excel knowledge is beginner at best! Need your help! I want to remove a complete row if cell B5 and below, and D5 and below are BOTH blank or show " " result from another worksheet. Many thanks
  2. E

    delete rows between a range of numbers

    I have the following code that deletes the entire row if its value is 900. Sub RemoveRows900() Dim i As Long i = 1 Do While i <= ThisWorkbook.ActiveSheet.Range("AA7:AA1000").CurrentRegion.Rows.Count If InStr(1, ThisWorkbook.ActiveSheet.Cells(i, 1).Text, "900", vbTextCompare) > 0...
  3. C

    Removing lines based on multiple criteria

    I am trying to eliminate certain rows in my workbook automatically based on a few fields. The file contains patient encounters with hospitals. Patient can either be discharged from the ED, admitted to inpatient, or discharged from inpatient. If a patient is transferred to inpatient from the...
  4. J

    VBA code to delete Rows that show "0" in Column A

    Hello Folks, This may be a quick one but my strengths are not in VBA [/URL][/IMG] I have a Source sheet that is linked to 1000s of formula and the whole thing is running horrifically slow. I need a way to eliminate unnecessary rows from the source data in a fully automated way. Luckily the...
  5. J

    How to delete the top and bottoms rows of each Text file in Power Query

    Hello, I need to set up a power query so that it for each Text file that is in a folder the top 8 and bottom 4 rows are deleted when imported. Is this possible and if so how do I do it?
  6. S

    Query Remove Rows - Null

    How can I remove rows based on cell contents being 'null'. I could manually do it in excel by using special to delete them but would like it as part of the query. My column which appears about halfway across my sheet is this. edit: number4 is the column header. <tbody> number4 null...
  7. J

    Merge duplicate rows, remove missing rows, and keep unique cells. Help please!!!

    I'm working on this workbook in Excel 2010. Each Monday I run a query of a backlog that is hundreds of rows long. Many of the rows are the same from week to week but there are always new rows and occasionally one of the old rows will be removed. Ideally, I would like to be able keep one main...
  8. L

    Remove all Rows that don't subtotal Zero

    How can I remove rows from my spreadsheet that don't subtotal Zero in the Subtotaled "CPT" Column. I only want to leave the group of data that has a subtotal of Zero in the "CPT" Column. This is the complete Sheet <TBODY> Practice Code Appt Date Pat Person Nbr Pat First Name Pat Last Name...
  9. MaxWol

    Remove different rows in 2 sheets

    Hi all, I have two sheets. Sheet 1 has 73.619 rows and sheet 2 has 41.470 rows. The values of column A in sheet 2 appear randomly in column A of sheet 1. I want to do 2 things: 1. I want to delete all rows in sheet 1 that have a value in column A that can not be found in column A of sheet...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top