filtering rows

  1. D

    Filtering to show changed cells - is it possible without resorting to macros

    We have a reporting spreadsheet, used by our PMs, with a text input cell for the PM to provide a brief update on the week's activities. I know I can Track Changes, which will put a small flag on a changed cell, but is there a way that can feed into another column/cell to show that the status...
  2. P

    filtering rows based on a cell input

    I have a file with 2 worksheets. The first one is for entering certain employee fields, and the 2nd worksheet shows all current employees. One of the input fields in the first sheet is for a JOB_CODE number. Is it possible to link that to the 2nd sheet where as soon as I enter that JOB_CODE...
  3. C

    Pivot Subtotals that 0 out

    I have a pretty basic pivot table, but it is rather large. This pivot is by order number. What I would like to do is hide all order number rows if the net activity zero's out in the subtotal. Can it be hidden or quickly filtered? The subtotals should only show non 0 rows. So in the example...
  4. A

    Excel 2007 filter problem

    My data has column headings (Unit, Reference,Description Amount Date) with currently 545 rows Date starts at 1 Mar 10 and ends currently at 10 Sep 10 Rows records information for each unit payments Auto filter is activated on column headings Excel does not show all of selected unit rows (shows...
  5. M

    Filtering out specific rows

    Excel 2007 running Winxp I have a huge spread sheet and need to filter out times. Example below: what i am trying to do is filter out all times except between xx:55 thru xx:05 10 minute window. Really 1 entry per hour around the top of the hour. This program creates an entry every 10 minutes...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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