filter

  1. N

    IFNA VLOOKUP with multiple repeating table arrays with filter

    Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail. I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...
  2. O

    Help with FILTER Formula

    I cannot use Mini-sheets our IT admin will not allow us to install outside programs. I am using WIN365 and WIN10. Here is a snap shot of a range, the red dates are within the 30 day window. What I am trying to do is isolate the Topics with red dates to one result. This next picture is my...
  3. K

    #When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. (VBA)

    When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...
  4. C

    Add current selection to Filter - Excel shortcut

    Hi all, Is there any shortcut key to "add current selection to filter " in Excel. Once we filter some items, and want to add another selection, how do we select those items first and then add current selection. Is there a shortcut key to this. Many thanks, Mustafa
  5. K

    Filter in multiple areas

    Hello to all, Im strugling to solve this for a week now. I would like to create filter something like: =FILTER(I4:I97,(J23:J40="PN")+(J42:J59="PN")+(J61:J78="N")+(J80:J97="N"),"") but always with error. This is just an example, I already tryed multiple variants of this, but still with some...
  6. B

    Macro not recording pivot table label filter correctly

    I'm trying to write a macro that involves copying data from a pivot table into a separate table. I'm hoping to keep positive and negative values separate because I'll need to sub those negative values multiple times for the data to be accurate and the "Label Filter" option seems to be for...
  7. K

    Filter will not compile!

    Hello, Because of the success after my first post, I've decided to come back as I'm quite stuck again.. I'm trying to filter a range of dates for a ceirtan date that is given in cell L1 in the "ws" worksheet, but I can't seem to be able to filter for this value. (for the record, my date-format...
  8. A

    Guys please help! Excel problem with index sort and filter function

    So i got this excel workbook that contains 2 sheets in sheet 1 column b - employee id column c - ranking on each equipment column d - employee name column e - date column f - worked hours for employees column g - shift (day shift or night shift) column h - equipment id in sheet 2 column a -...
  9. L

    Use a cell reference to update a filter command

    Good afternoon, I need to be able to change the filter range by referencing a single cell BN2 = [Jan 23]. The difficulty is the table reference, FeesInvoice[ x ] (Cell Reference BM4) =FILTER(FeesInvoiced[Project Number],FeesInvoiced[Jan-22]<>0) (Cell Reference BN4)...
  10. Chris_010101

    Excel VBA Help, Filters

    Hello, In column A, I have: =SORT(UNIQUE(FILTER('Headcount Report'!A3:A909, 'Headcount Report'!A3:A909<>""))) which pulls a list of unique values. In this list are locations by type, i.e St Albans - Yard, Colchester - Transport. The three types are "Office", "Yard" and "Transport" all appended...
  11. E

    Count filtered unique values where sum of values in another column meets criteria

    Hello, hope you can help. I would like to use a formula to give the count of complete projects in [time range] where there is a total of <=1 hour spent on 'review' over the whole project - example sheet below. In this sample the desired answer is 2 as only project A and B meet the criteria...
  12. H

    How do I create a table that then considers whether or not clients appear in other tables?

    Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...
  13. D

    Textjoin Calc error help

    Hi, I seem to be having error when using Textjoin. The worst part is that it was working fine, but file didn't saved and when I tried to replicate the formula, I keep getting now error Calc and cant see where is the issue. I have few tables, consisting of 2 columns each. 1 column has list...
  14. D

    Vstack ignore blanks

    Hi, Is there a better way of using vstack but ignoring the empty cells in each list that this; VSTACK(FILTER(Table2[A],Table2[A]<>""),FILTER(Table2[B],Table2[B]<>""),FILTER(Table2[C],Table2[C]<>"")) Richard.
  15. S

    Is is possible to add searchable text into the same cell, similar to how hashtags work

    I'm creating a product table in excel containing about 200 products. Each of these products can be used as a component in multiple applications and they can have multiple useful descriptions. Some products might be usable in 10 or more applications or have similar descriptions. Rather than...
  16. Y

    Need a Macro code to filter & unselect a specific value.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...
  17. J

    Can I overlay Filter( ) formula over SUMIFS formula?

    Hi Excel Experts! Hoping to find some help with the below. I have made a dummy dataset. But basically I am trying to find an automated way to sumifs the dataset, then remove rows with all 3 blanks. Is the Filter( ) formula appropriate? or would there be an alternative formula to make this more...
  18. T

    Function that will collapse 4 rows of data into one row based on the first two columns information.

    Hi All, I am currently working on making a workbook that takes data from a data base and consolidates it down to a easier read. I currently have a system that shows when people call into our system, the problem is that this system creates a row of data for each entry and I would like to take...
  19. mrraulipina

    Selecting specific columns in a Transpose unique formula

    I have a table extract and i'm using a combination of transpose and unique formula to bring in values onto Q2. I'm trying to filter this data so it only brings in column D, E, I L, and O. I keep trying to use the FILTER function but I get errors. I only need the yellow items in my example...
  20. N

    Filter get these days = Now - 5 days (by vba)

    Hello all, I searched the forum but couldn't find this question, as the titles I want filter get these days = Now - 5 days (by vba) Today 16 Feb, I want to filter get 15,14,13,12,11.

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
Back
Top