1. P

    Show Table Filter Criteria In Cell

    Working on UDF to display the filter criteria for a table. UDF would be just above filtered table. Found perfect UDF but only works on normal filters, not table filters. Having trouble adapting it: Function Show_Criteria(Rng As Range) As String Dim str1 As String, str2 As String Dim tbl As...
  2. G

    Delete rows depending on number of columns

    Hi, I would like to know how one can delete multiple rows depending on the number of columns that they have. For eg. say I have 100 rows and the number of columns with data are different for each row. Now I only want rows that have exactly 10 columns with data and delete the ones that dont meet...
  3. E

    Sheet Name But Referencing Column Letter

    Hi, Overall I'm trying to use a filter function with data from a separate sheet. Problem is the data is not very consistent and the column headers move around. I can use the address and match to find my column letter in the other sheet but I want to be able to put it back in to an overall...
  4. C

    Filter based on specific list of values

    Hello, Hoping for some help/point in the right direction. I have searched this forum, as well as Google and YouTube. I have a filter enabled, and rather than having to select every specific value each time, I want to be able to point to a list of values that I would be filtering by...
  5. B

    Using Filters with Indirect lookups

    All, Please see below and let me know what you think. Right now my formula works and is looping back the correct data based on A2. However, what I want to do is turn that A2 into an array of cells (i.e. &$A$2:$A$100&), so when a new project is added to that column A (say it is on A3) it will...
  6. A

    Auto filter based on yesterdays date

    Hello all, I have an autofilter that I am trying to have match yesterdays date, and I am struggling to make it work. I am trying to show all values that do not match yesterdays date so I can delete all those rows. Selection.AutoFilter ActiveSheet.Range("AU1:AU" & Lastrow).AutoFilter...
  7. N

    Formula Help

    I build a simple spreadsheet to keep track of the job numbers I work on through the day. In order to get paid, these job numbers have a corresponding SR number that I am pulling from a table. Some jobs may not have a SR number, so those need to be requested. I made a simple formula that should...
  8. G

    DAX Distinct Count Measure

    Hi, would appreciate any help with this, I have a List of Users and Dates they logged on over the last few years, I want to create a meaure which counts the number of Distinct Users who have logged on in the last Calendar Month and the Last 12 Months depending on the Month selected in the...
  9. C

    Power Query Merge with conditions/filter

    My problem comes with a merge between Employees table and Home Location table. I have an employee list as my main table that I am joining to and I need the Home location based on where the employee worked the most amount of hours. The Home Location table takes all of the hours for the time...
  10. Chris The Rock

    Searchable Data Validation Drop-Down using a FILTER() function..with a twist

    I've just been made aware of the technique for making a drop down list with data validation searchable, using a Dyanmic Array function, FILTER(). The examples I've seen, however, are those with a single cell containing that drop-down list. And I have this technique mastered. However.... I...
  11. L

    Help figuring out how to do this.

    Alright, so a company that I work with makes racks for a large company to use. They are new and I go in every day and watch the racks when they get placed and make note of the rack number, time in and out, any issues that come from the robot etc. So we are trying to figure out now, an easy-clean...
  12. A

    Advanced Filter: contains specific text

    I put together an advanced filter to only show rows that match my selection from a drop-down menu. I used function =IF(E6=“”,”*”,E6) and recorded a macro to extract data from one sheet and display in my filtered table on another sheet. It works well, but I’ve run into a wall. I have some cells...
  13. A

    How to filter a pivot table with an ActiveX combo box set in another Sheet?

    Hello everyone, I am having a lot of problems in finding some material which could help me learn how to filter a pivot table with an ActiveX combo box set in another Sheet and I was hoping in some help of yours. ;) I would like to make a dynamic combo box, which updates automatically whenever...
  14. A

    Copy rows onto another worksheet based on multiple criteria (dynamic criteria)

    I'm trying to copy rows from one sheet to another worksheet based on a number of criteria (currently from a dropdown). I am currently able to do this for non-dynamic (non-changing) criteria using either an excel formula or VBA coda (which is much faster). However, how can I set up my macro so...
  15. 5

    Filtering a 2D array in a listbox from a textbox

    Hi everyone. I have a userform with a textbox and a listbox. The listbox is populated with data from a 2-column ListObject table whenever the form initializes and, as I type in the textbox, it gets filtered using the full string. That works, but since I'm filtering construction materials, I...
  16. A

    Format each group of three columns as Tables

    Hello All, I currently have a workbook with 3 sheets Sheet 1: I use the =FILTER() Function to filter the data into only 3 columns for better presentation. Each set of data (the three columns) is presented in Cells A7:C100, D7:G100. I7:K100 etc. The last set is on GK7:GM100. Sheet 2: Is the logic...
  17. S

    Date Slider, Advanced Requirement, Question & Advice

    Hi, I have a bookmark that pops out for filtering a report. I already had a filter in there for a Relative Date field for Next 2 days, the reason being, this field filters the report for the current day at all times as our client works around the clock. There is a now a requirement by the...
  18. A

    Filtering data causing formatting issues

    I have a project for uni that I have to do but these 2 problems are standing in my way. I have a picture of what the table should look like after it's been filtered Here you can see that I need to have 2 tables side-by-side. Left table is sorting data based on value from it's furthest right...
  19. R

    How to Filter Combo Box as User Typed?

    I have using one of ComboBox in UserForm and load the values from code behine function called while Userform Iniated. I need that ComboBox should filter and show as what user typed. Eg: Values are "OUTLET, SALES, SUPPLIER, SALES CATEGORY, PURCHASE, SALES MODE" User type as "SA".. list items...
  20. M

    How to get the range of filtered data? (Not formatted as table)

    Hello First of all, few disclaimer from me Im new to here, and also relatively new to VBA although i did experiment here and there through macro recording then edit them to understand the basics Im non english speaker, so i may lack of vocabolary when speaking english in spesific field like...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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