filter

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

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

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

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

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

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.

Excel formula for multiple matches. Kindly help to find a formula in G3 and G4. I have data in column B and C, I wanted to match it with column E and F. However vlookup does not work as there are multiple matches. I wanted a result of True/False if B and C contains the values in E and F...

Hello In the following code, I would like to put the Row number of the first line with Data in a variable. (or be able to start my selection from the first line with Data in column A) Right now, my script works well, only when the first line with Data, is Line 2...

Hi there, I want to create a table where a user can enter data for a 'Stock Alert Message'. The data entered will consist of a Stock Code, Group, Type and Category. I would then like to run a query against this table which will only show us Stock Items which have an alert. I'm struggling with...

Hi, Cross posted Excel Forum ; https://www.excelforum.com/office-365/1399068-dax-filtering-between-dates-with-keepfilter.html#post5787380https://www.excelforum.com/office-365/1399068-dax-filtering-between-dates-with-keepfilter.html#post5787380 Can someone help with this I have...

Hi, Just wondering... With modern Excel's improved abilities to handle arrays and to spill, and considering the awesome FILTER function - I'm just wondering if there is still a need that only SUMPRODUCT can fill in today's Excel world. And if the answer is, "Yes, there are things that only...

Hi everyone, I have three columns A, B, and C and I want to filter the rows that pertain to one of the drop-down list selections that I created, what would be the formula for this? For example, I have listed the first, second and third job preferences of a number of people. I would like to...

If I use Text.Contains to have 1 filter only, it works fine (e.g. only those containing "@"). However, I want to combine the filters into 1 query so there won't be so many steps. Therefore, I'm using List.ContainsAny instead. I think it's because PQ cannot pick up List.Accumulate's "current" if...

So it's not really a question (unless anyone has a suggestion for a better way to go about it) and if this isn't the place to post this sort of thing please let me know, but I've put together a sheet in my budget that tracks the account that my bills are set to auto-pay from and forecasts out...

Hi all. I have a spilled FILTER list of a database that gets updated every day with some reference numbers and other columns. Every week or so I must analyse these data and fill in another column with the results of the analysis. Both the database and the filter are sorted by date. Now, since...

I have a spreadsheet that I haven't refreshed since the middle of November 2022. When I refresh the data today, the chart shows every month instead of only the filtered month! Has something changed in excel since November 2022? This used to work, but now doesn't, and all I did was RMB...

I have 3 columns, where column C should only display the information from column A if column B contains "NO". Any suggestion? A B C (if B has "NO", bring data from column A) 20786WAD - FPAC - GLBL - BTRS NO ABMD NO LFG NO

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare. How can we solve it in the shortest possible way...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare.

PART 1) I have a workbook that we keep track of all help hired along with a bunch of other information. I wanted to create a tab that will use the following criteria (State, Date Range, Used Multiple Times, Rehire Status) to retrieve the names of anyone who fit the criteria that is filled in. I...