filter advance criteria

  1. J

    How to count only numbers in column

    Dear All; i am facing some problem in counting the numbers actually i have one column and it contain thousands of data both in numbers and in strings/ alphabets. can anyone help me in this regard how i can count only numbers out of it....
  2. N

    vba Delete Row(s) not matching table criteria Macro

    So i'll do my best to try and explain this. I have a spreadsheet with 2 tabs (DataExport; FilterCriteria) The DataExport tab is every computer i pulled from active directory (real long list) Column A is the PC name and Column B is the OU it resides in. The FilterCriteria tab Column A is a list...
  3. J

    Loop through Data Validation list in Advanced Filter Copy Paste all Results on one sheet

    I am having an issue with looping through my advanced filter that loops through a data validation list then needs to copy each filtered data result into one sheet, one after another. I am able to get the data validation to loop through each drop down selection and filtered each persons results...
  4. LottoMatic

    Excel expert advice needed

    I am looking for the advice of experienced Excel users regarding the "translation" of a web-based application into an Excel spreadsheet and really hope to get some useful input regarding this matter. Since year 2014 I've been working on a rather complex lottery prediction system. It is a...
  5. S

    Pivot table. Hide blank and show top 10.

    Whenever I try to do this it ends up deleting one or another filter. It is very not surprising to me as it filters same columns, But it also happens when I try to filter value over say 300, which seem to be different columns. Is there a way to hide blanks and show top 10 or alternatively hide...
  6. J

    Incorrect result when working with Max Date

    I need some help as I get an incorrect result and I can not solve it. I have a table with following fields: - Ordertype ("Actual" or "Forecast") - CustomerNumber - OrderNumber - DeliveryDate - Plant - Material - Volume I have following measures - Sum of Volume = SUMX ( FactData...
  7. S

    Find a number from multiple range of numbers

    Dear All, I have two tables as mentioned below Master Date Table No.1:- <tbody> Serial No. Quantity of Cards Start No. End No. Invoice No. 1 500 193201 193700 1A 2 1000 199701 200700 1B 3 1000 214301 215300 1C 4 1000 223101 224100 1D 5 1000 235101 236100 1E 6 1000 239601 240600 1F...
  8. X

    Seeking assistance with criteria based sort and filter.

    I have a spreadsheet w/ approximately 40K lines of data. The data is formatted into 3 columns – employee name; week ending; avg. hours worked. Is there a way for me to filter this data in such a way that it omits employees who do not have any hours or entries for the prior two weeks? In the...
  9. J

    Displaying multiple matches based on multiple criteria.

    Hi, so I've been looking around for a kind of self-project that I have in mind. I got a list of different descriptions with variable components, basically my idea is: if I have a certain amount of this component and a certain amount of this other component, display all the matches based on the...
  10. T

    Filter one dimension in a visual

    I'm new to Power BI. In a simple barchart i want to filter one specific dimension: For planning category A I want to see my data from jan till dec. For planning category B I want to see my data from feb till dec. When i filter using the visual filter i set a filter voor planning category A...
  11. M

    Filter for text that does not match in two different columns

    Hi all, I have a Sub that currently works to automatically filter 3 different words in two columns in my workbook. What I am after is for an change up of this macro: so that it will filter when column 1 = "SentProgress" does not match column 2 = "ReceivedProgress". An example of this would when...
  12. W

    Filter code works on text but not numbers

    Hi All, This is a similar question to another thread:https://www.mrexcel.com/forum/excel-questions/1081373-code-works-text-not-numbers.html I've tried the solution suggested on the thread but still isn't working for me. The column I am filtering on has numbers in text formats, such as "004"...
  13. T

    dynamic date range using autofilter not run

    Dear Mr excel In Chapter 12 I run Macro Dinamic date range using Autofilter not run, Please help me Sub FilterDynamicDate() ' Page 255 Top ' Bug in the beta Worksheets("NewFilter").Select Range("A1:A1").AutoFilter Field:=3, _ Criteria1:=xlFilterDatesinPeriodQuarter1...
  14. S

    filter? group? multiple rows based on values in 2 cells

    <tbody> Cost center Dept Account Desc Budget Actual $ Var % var 712 Acctg Revenue 10 1 -9 90% 712 Acctg Salaries 5 8 -3 60% 712 Acctg Total 5 -7 -12 240% 814 HR Revenue 10 10 0 0 814 HR Salaries 11 11 0 0 814 HR Total -1 -1 0 0 </tbody> Let's say I have the above table...
  15. A

    GETPIVOTDATA Relative Reference and Cascading Slicers to Sort Students and Test Scores

    Hi All, I could really use some help before I go jump off a bridge. Jk. The issue I am currently having it related to using relative references in the GETPIVOTDATA function and cascading slicers. I have a PivotTable set up that has a list of students and their test scores. What I would like to...
  16. G

    IF outcome depending on filter value

    I am making a macro that will send out an email to different people depending on the value of a filter in cell C1. I have managed to compile the macro to work depending on a cell value (cell C2) however as the cell value does not change when the filter is applied I need to select the different...
  17. K

    Ongoing and interactive Filtering

    When a certain word or set of text is entered into a column in my table, I want that entire row to be copied and placed on another sheet in the workbook. Say you"re inputing food orders into an excel table. You want all the orders to be on one sheet entirely, but every time someone orders a...
  18. M

    I need help with VBA & Excel to filter on multi level

    Hello, I have added the code to filtrer by pressing the button under the filter column and it work. However, I need to be able to do more than 1 filter. IE: Cell b1 and b2 is from invoice # X to invoice # X -> click on the filter button = filter only these invoices. Cell c1 and c2 is from...
  19. A

    Vba Code For Copy data one File to Another File in excel

    Hello, I need help for Vba Code For Copy data one File to Another File in excel, Scenario: * I have file one which I want copy and paste another file but in this file Data have merge cell A:A so first I want unmerge this cell. * then I will Do cell C:C text to column for Date and Time...
  20. T

    Filtering data using specific format

    Hello All, Currently I have 2 columns of data, each contain about 100000 records. First column contain Folder names (Image, Birthday, Job,...) and the second contain the name of files and sub-folder that in that folder, each row is a different files/folder. Something like this: <tbody> Folder...

Some videos you may like

This Week's Hot Topics

Top