filter by multiple values

Hello all, I'm in a bit of a bind. I need to execute a filter on a column that has fifteen criteria. For example, does not contain "*sandwich" OR does not contain "*pants" OR does not contain "*tortillas" etc etc etc...... They are all "does not contain" and "OR" operations and they all...

Hi ! This is what I need to do: I have a range (lista) that contains strings in column 2, and I want to filter it by those cells that contain any of the words in a string called myarray. Being myarray for example {"one","two","three"}, i would need to filter lista by the cells that contain...

Hi, Hopefully some sharp brains that could help me out.... :-) I have a dynamic drop down list in B3. The dynamic drop down list in B4 is a result of my choice in B3, and my dynamic drop down list B5 is a result of my choice in B4. When changing a value in B3 the drop down lists B4 and B5...

Hello, I'm trying to add code to an existing macro that is working well to add a feature. As it sits now, my code produces a worksheet tab called "Matrix" that has headers in row 1, a variable length list of employee names in column 1, and then a variable number columns with data...

I have a problem organizing my data into worksheets with consistent variables. I am looking at: |company name (A1)| Fund Name (B1)| Valuation (C1)|, however not all companies are in all quarters. Basically, the company name and fund need to be consistent over the 20 worksheets. Is there a way...

Hi! I've got an old Excel sheet with Stephen Bullen's function for returning the active filter criteria (Rob on Programming: Excel: Displaying Autofilter Criteria). My status sheet may be filtered in multiple ways, and when the user is happy with the filter selections, she can create a...

Hello users, I would like to create a macro that filters for A and B ranked items and then sorts the list by the items Start Date (Newest to Oldest). this is my Macro as of now but I'm only getting B Ranked items, no A ranked. Any suggestions? Sub NewerSKUS() ActiveSheet.AutoFilterMode =...

Afternoon, I am encountering an issue that I do not know how best to explain. I have an on_open macro that refreshes some queries and sends some emails out based on some thresholds. Now the emails are sent out based on the filter that is applied. If I open the file manually, it works great. I...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility>...

Hi Guys, Really need someones help on this! I have a listbox "EventNameListBox" with contents displaying info on clothing etc that gets its info from Sheet2, all works well but I need is to filter the contents in the listbox even further. I need to filter the contents in the list box to display...

Hi, Really struggling with a bit of a "minging" spreadsheet.. Each client has multiple rows (1 for each claim) and each row has 2 status fields (I2... and K2...) Theres a unique ref in column B which shows if they relate to the same client. I need to identify/filter the clients that have a...

I have successfully texted to columns and delimited the info I want. The next step is to sum the numbers relating to the time of day for each day of the year. But apparently, Excel will not allow me to perform that function. e.g.: <TABLE style="WIDTH: 292pt; BORDER-COLLAPSE: collapse"...

Hi All, I need a formula to count number of records for the following condition. we need to satisfy these conditions like filtering the data using the conditions and then count the records, i can use pivots but i need a formula as i perform other calculations on different workbook.Kindly...

Filter: ProfitCenter 202201 Row Labels Sum of CompanyAmount 3000202 $2,017 3000208 $711 3000468 $6,668 3000647 $33,961 3000900 $55 3000911 $11,946 3000914 $5,548 3000948 $37,848 3001024 $12,510 3001331 $442 Values to be entered in the filter: 202201 202103 202503 and more...