filter

I am using Excel 365. I cannot use mini-sheets, because of security reasons. What I am trying to accomplish is write a formula that uses the table to the right as the array. I want it to return only the last and first names of the people that have amounts due. The right hand table is named...

Hi, I have a named range in my workbook and when referencing it I can select the individual columns within the range. When I reference the range =RangeName and include the first square bracket =RangeName[ It then shows me the various columns that I may select from that range this is great...

I have an Excel 365 spreadsheet with a Table called "Table_Data_Entry". Row 2 of the spreadsheet contains all the Table headers. The first header (in cell A2) is "Date". All the headers should have a Filter/Sort icon, and they used to, but now the Date header does not. I cannot replicate this...

This is (kind of) in continuation to the post - https://www.mrexcel.com/board/threads/filtering-a-list-further.1251399/ Where @Fluff gave me a suitable solution as per the times. Since I have upgraded my system to Excel 2024, I thought of doing things differently and efficiently. Can't say...

I'm having an issue with a FILTER function that is just sending back a value of #N/A and the error help obviously doesn't say too much. Hoping someone here can help. My formula is =FILTER(TimetrackedLogs!$A$2:$N$200000,TimetrackedLogs!$N$2:$N$200000="my_value","No results") Column N in the...

Hi, I'm trying to figure out a way to count the unique number of values based on two criteria, where one criteria is dependent on a list (named range). =SUM(--(LEN(UNIQUE(FILTER(Table1[ID];(Table1[MONTH]=$S$1)*(Table1[VALUES]=NamedRange);"")))>0)) What would the best way be to count the...

I've got a range of letters, and I want to calculate how many unique values occur in it, excluding the letter A and empty cells. I've used the formula =COUNTA(UNIQUE(FILTER(A1:A10,(A1:A10<>"A")*(A1:A10<>"")))) which works fine, except when the result should be zero. Here are some examples...

I have tried a number of formulas to get this, and I keep getting circular references. My use case is a construction project budget, where I have a hierarchy of categories. In a single table, I want to make the inputs AND see the rollup (I am familiar with PivotTables, and they do not fit this...

Sheet1 has a list of vehicles that are booked for maintenance as follows: Week NumberDateVehicleMaintenanceComments 4214/10/2024ABC1InspectionDrop off early 4215/10/2024ABC3ServiceNightshift 4401/11/2024XYZ20MOTAfternoon Sheet2 needs to draw the relative information from sheet1 for...

I currently have the sub-Macro below which filters for Columns A and B (for Strings Asset and SN), and then copies the value. What I'm trying to figure out is how do I set it so that if no results are found for either, the macro would generate an error instead of crashing/copying just the title...

Hi colleagues, I'm having lil bit issue with my Filter formula. So, basically I have 1 master data for scoring and in other hand i need to disclose some certain range that meets some condition. Have a look in uploaded pic. On the left table is the master data, on the right I disclosed some...

XREPEAT is a powerful/highly versatile repeating and/or stacking solution for repeating single values, rows or columns; or stacking arrays/ranges allowing for filtering out or inserting blank repeats/stacks, partial stacks, or (partial) 'stacks of stacks' XREPEAT works with any data type, (i.e...

Hey all, Yesterday, we created this formula and it works well. I now need to be able to filter the returned results by a date range. I have put the start date in D5 and end date in E5. I have tried several different approaches and can't seem to get it right. I have a feeling I am on the right...

Hello all, I am trying to create a report that shows all cleaning failures over the course of a month. Failures are called both "Failed" and "Aborted". The formula I have been using works well for Failed. However, I need to be able to search for both of those terms. Everything I have found says...

I've come across a strange behaviour of Power Pivot related to measures on fields of detail tables. I have the following simple model: Grades (Grade code, Target Utilization) Team (Name, Grade code) <links to the Grades on Grade Code> Forecast (Name, Period, value, MaxValue) <links to Team on...

I am using below code by @Anthony47, which is working fine, now I just want to modify code and instead of copying data in to clipboard I want to save each filtered name as separate image in a folder for that it should ask for destination folder and want to name each image same as the name...

I wrote this code to change different pivot filters in order to compute different values each time (region level, subregional level, MBU level, and FID level). The filter changes when I use the slicers connected to the pivot table. How to ensure that the filter is reset once I the cell value...

Hi! I have a huge list (60,000) of contact data including information I want and a lot I don’t need. It is unevenly spread across cells in a way that isn’t patterned throughout (like some of the data is in correct columns but some is not). I basically want to delete the excess data and sort the...

good day mate, need some guidance again, my code do run when not filtering between dates! but when I include the Date Covered in the range it does not show/filter intended record(s). Sub AutoFilterDate() Dim sDate As Long Dim eDate As Long sDate = Range("H1").Value eDate...

Hello Guys! I would like to ask how to do this, this is for filtering some Columns? Thank you very much.