1. B

    ??? -- Filtering Slicer Output with another Slicer, based off of the original dataset that was filtered... ... lol

    I realize that sounds absolutely ridiculous, but the concept is very much what I need. This is based off of System Condition Codes (SCC) for Work Orders in SAP. I have two columns of data - FROM (starting Code) and TO (finish code). Each digit (alpha/numeric) has a preset limitation to what...
  2. D

    Range.Rows property with autofilter applied

    Hi MrExcel, I need your help. I have an autofilter applied to a range resulting in non-continuous set of rows visible (see snapshot). Assume I want to access the number of the first visible non-header row (which is number 7 in this case). When I run Dim rng As Range Set rng =...
  3. V

    Declare a variable to a cell

    Hi everyone! I've been stuck with declaring a variable to a cell value and need some help. Situation: I have a code that filters a table and transfers the filtered data to another sheet. The filter could be the date value but I can't set it properly. The result is always Error 1004. I've tried...
  4. S

    Advanced Filter query - What are the rules with editing the extract?

    Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and: 1.) Sorted the Extract 2.) Made some changes to the Extract Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes Other...
  5. G

    Filter Everything, Except for a Single Criteria

    ActiveSheet.Range("$A$8:$AH$1894").AutoFilter Field:=1, Criteria1:=Array( _ "NOT STARTED", "ON-HOLD", "STARTED"), Operator:=xlFilterValues ActiveSheet.Range("$A$8:$AH$1894").AutoFilter Field:=2, Criteria1:="NCR" Hello All, The Code above is working to filter only "NCR" (after Field...
  6. H

    Select Filter based in Value

    I would like macro to select the filter in A2 (Financial Year") on sheet summary if Cell c10 on sheet "Data" is zero, otherwise select highest year from Filter Your assistance is most appreciated <b></b><table cellpadding="2.5px" rules="all" style=";background-color...
  7. H

    macro to select year in Filter omn Pivot table

    I have a pivot Table on sheet "summary" Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year It would be appreciated if some could provide me with code to do this <b></b><table cellpadding="2.5px"...
  8. A

    Filter search in MS Excel 2007

    Hi everyone, I request you to send the code to enable Filter search in Excel 2007.
  9. L

    advanced filter - OR vs AND

    Hi Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this I understood all the above but what I do not understand, when I use a regular filter to filter...
  10. S

    DAX Countrow Filter Userelationship not working together

    Does anyone know why the DAX below is not working? Do I have it in the wrong order? BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]), FILTER('Schedule','Schedule'[WO Type]="BTS") USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed])) Power BI just keeps...
  11. D

    Copy and Paste Row not working when filtered

    Hi I have the below code(below) that works off a button, to copy an entire row it works fine, however for some reason When the sheet is filtered, it just inserts a blank line, any ideas? Sub Copy_paste() Dim MyPassword As String MyPassword = "Yes" If InputBox("Please enter password...
  12. J

    VBA Code to Automatically Re-apply Filter

    Hi - does anyone have a working VBA code to automatically reapply a number filter on greater than 0? I have tried 3 or 4 codes that I found by searching but none of them actually seem to do anything! It is possible that I'm doing something wrong in the applying of them though.. :confused:
  13. A

    Data Validation List based on Cell Value

    I have a table in which currency in A and values in B <tbody> CAD 2 USD 13 AUD 15 CAD 5 CAD 11 </tbody> I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.
  14. willow1985

    VBA code - filter: show all data and then remove filter

    I have a code that shows all data on a filter but how can this code be modified to show all data AND remove the filter? If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then ActiveSheet.ShowAllData I have to use this multiple times throughout the code. I...
  15. M

    Apply filter on one column of a pivot table

    Hi I need to use a filter on my pivot table. (Placing the field into the folder box) I only want this to apply to one of my columns - is this possible? Jess
  16. D

    Filter on row numbers not cell contents

    Hi, Is there any way to filter on a large amount of row numbers not the contents on the cells? Thanks
  17. L

    Using Excel Filter to Search for text containing a comma & displaying all records that contain one

    I have a list of Email Addresses in an Excel File along with other columns. I Filter the email column to search for mistakes, like double periods (..) which works fine in the filter. But when I search for a comma (,) it's not allowed. Sometimes people type a comma for the period (by accident)...
  18. J

    Autofilter / Advanced Filter Copying over all data

    Hi, This is a bit frustrating. I've applied code to filter data using the autoFilter function but when I apply a new line with AdvancedFilter it appears it clears the filtered range and copies over all data With Sheets(1).ListObjects("Table13256").Range.AutoFilter Field:=22, Criteria1:="<>"...
  19. S

    Delete rows if condition met without using filter

    I wanna select rows and delete them without using filter. The reason is that the Model No. is common but customer code is different and sum of required qty. is also different. So i want to keep only those customer code rows which sum is greater than other customer code rows. I have a very large...
  20. M

    VLOOKUP using hidden/filtered data

    I have a list of prices, products, customers, etc. that are in categories (Beef, Chicken, etc.) and in subsets (Salisbury, Ground, Raw, etc.). I am using the Aggregate function to determine the lowest price. Then, I use the VLOOKUP function to search that lowest price for who is purchasing...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...