filter

  1. H

    Combination Filtering

    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...
  2. A

    paste results from filter function in 2 columns

    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...
  3. Z

    Drop down list using unique but with changed number of rows

    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...
  4. A

    Macros for cleaning excel file

    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...
  5. C

    How to group filtered data

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

    How to combine IF and FILTER formulas to copy text from one column to another

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

    row to column - vba or code or formula

    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...
  8. G

    Choose function under the filter function isn't working properly

    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...
  9. M

    create table from data on second sheet

    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...
  10. opazzo

    Can VSTACK return formulas instead of values ?

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

    Sum-Unique - filter

    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...
  12. S

    Substitute FILTER function in Excel 2007

    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.
  13. L

    VBA Filter all unique values and sum totals

    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.
  14. B

    Find column by header AND filter by another column?

    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...
  15. D

    DAX Filter by values found in a column of another table

    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 (...
  16. SanjayGMusafir

    Filtering a list further

    Hi Experts This is the power of Excel - That you start to believe can I go 1 level further. Recently I had a thread - https://www.mrexcel.com/board/threads/filter-unique-values-out-of-a-multi-column-list.1251328/post-6140661 where @Eric W @ISY @Fluff gave me the solution. Due to my system...
  17. SanjayGMusafir

    Filter Unique Values out of a Multi-Column List

    Hi Experts, I wanted to get a one column list out a range. So far have been able to extract a multicolumn list. But I want it to be one column list so that it could be filtered further for unique values. Got kind of stuck somewhere. Please help Thanks in advance Underneath is the formula I...
  18. G

    How to filter a table with two email columns against a list of emails

    Hello! This sounds so basic, but I swear I've searched for a long time and can't find exactly what I need. I have a list of (usually thousands of) contacts with multiple columns (E.g., let's simplify to: first name, last name, personal email, work email, phone) that I need to clean against...
  19. F

    If Column is X, display text

    I have a list of names and all the countries. Column 1 is filled with names and the following columns represent all the countries of the world. In each row, there's an 'X' under the country that person has visited. On another tab, I'm listing some of these names using the formula FILTER. In the...
  20. R

    Inserting a mailto link into an email body to a customer, based on a cell value.

    I really don't know how to state this one better. I'm creating a spreadsheet that will take a customer's email address and Generate an email to inform them who the contacts for their selected job area are. I designed a sample spreadsheet: And my goal is to produce the email so it has a link...

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