filter

I keep getting a Div/0 error with this formula =FILTER('Job Register'!A:AT,(ISNUMBER('Job Register'!AT:AT))*(('Job Register'!AT:AT<-0.02)+('Job Register'!AT:AT>0.02))) My column AT has both blank cells and #div/0! cells. Any help would be appreciated, Thanks

I've been working all day to no avail. Not sure why table is not filtering when activating this macro. Option Explicit Sub AgentFilter() Dim aQuery As String Dim LastRow As Long With sh_AGENTS LastRow = .Range("C999999999").End(xlUp).Row If...

Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...

I need to lookup & return an interest rate between date ranges. Any date between June 1, 2020 - March 31, 2022; return 2.00% Any date between April 1, 2022 - June 30, 2023; return 3.00% data table 2.00% 6/1/2020 3/31/2022 3.00% 4/1/2022 6/30/2023 3.92% 7/1/2023 12/31/2023 5.33%...

So while I know, ultimately, that I can do what I'm about to ask with a custom sort, I have a shared spreadsheet that is constantly having rows added, and deleted (I.E. they add to the bottom, but might just delete row 5), which means that I would have to redo the custom sort EVERY TIME I HAVE...

I have 2 sheets Form_ERR and DataBase_ERR. Form_ERR has: - Cell L11 - where a number can be entered Cell L14 - dropdown selection containing Names Cell L16 - dropdown selection containing Categories Cell L18 - dropdown selection contain Departments Cell L20 - dropdown selection containing...

Is there any way to take the data that is pulled from a filter function and split them into 2 seperate columns. As an example, I have data in Column A and B. I am filtering the data using a critria in cell D1 to match in B column. The fucntion pulls a total of 10 results. Can this data be...

Hi, I was able to create a a data validation list by using UNIQUE, however, my rows may change whenever I update the template. Can anyone advise how can I change my current formula to consider the rows changes...

Hi This is the original file for which I seek your kind consideration. This is the desired output file I need your kind gesture and help to get the output file with the following parameters Delete Column A ,C, D ,J,K,M,O,and P to AH completely. After the given columns are deleted I request...

Hi! I'm looking for some help in grouping sets of data for when a filter is applied. Example below: Says below is the original set of data - I would like to be able to filter by tests that have "failed". Is it possible to keep all of Test number 2 & 4 showing when I filter for "fail"...

I am coding qualitative data from call center agent notes, and I'm trying to adapt another researcher's Excel method. I've adapted it a bit for my own purposes, and I just can't seem to get this last piece. I'm using Excel for Mac version 16.81 So, I have all my agent notes in Column A. In...

we have the following data and we have copy the sheet1!B2:C2 and pasted on Sheet2!B2 and transposed it, again we have copied the data from Sheet1!B3:D3 and again pasted on Sheet2!B3 we will copy the data and check last filled row in sheet2 and paste transposed data in sheet1 data may be long...

I am using excel365 online and but have excel2016 downloaded onto my computer. I am getting error messages but not sure why. The formula that I have is as follows: =FILTER(CHOOSE((1,2,3),'Employee_Name'!A:A,'Employee_Name'!J:J,'Employee_Name'!B:B),'Employee_Name'!G:G="Bob","") I have changed...

Please tell me to go away if you like. I have a table full of names (starting at B3 to H3), column A has which sites to work at. I need to 'transfer' the data in columns D to H from this table to another sheet depending on the site in column A I think this is a VLookup or a filter formula...

I want VSTACK to return the FILTER formulas across spreadsheets (same location), not the values. Is that at all possible?

I am trying to do the following on a summary tab: 1. Perform a summary calculation of common part numbers 2. Display the total qty as a unique row displaying the total qty of the duplicate part numbers into col "A" on the "SUMMARY" TAB 2A. If all the rows of duplicate PN qty are 0 then omit...

I have a table like the one attached. I need to get distinct values in column S (client name) but only of the records having a specific column A (supply code) value (OTT23 for example). Is this feasible without using FILTER function? Any help is much appreciated.

Hello- I have a file that changes monthly that I need to utilize vba to filter all unique values (that will change every month) in column D and add up values for each unique value from column L. Any help would be appreciated! Below is a sample of what it looks like. The dates change monthly.

I'm working on a table that references another and returns the number of employees in each of several regions, by year. The source table includes a row for each employee, with a value of '1' in the column for each year they worked: Destination Table: Year Region Employees 2020 a 1 2020 b...

I hope this illustrates what I would like to do i fist have a virtual table filtered for just green products, and then a second for just red , I would like to filter the second table to show only customers or whatever that are contained in the first; EVALUATE VAR ttable = CALCULATETABLE (...