multiple critera

Wasn't too sure how to word this, but here is the situation: - A table ("Table1") with several columns; focus is on columns 1,2,4 - Column 4 contains a dropdown menu, which uses the list called "Steps", which is defined as G2:G6 - I need to find a given person's most/least progressed step (the...

Hi, I've been trying to get my head around how to sort (by multiple criteria) in a filter but can't seem to get it to work. The original filter also included CHOOSECOLS but I have tried to remove that to troubleshoot but without success. The filter (pulling data from a sheet named DATA) is...

Hello my fellow Vba coders My worksheet contains a table where I want it filtered based on two separate dropdown list. The user will first filter cell B3 where the table filters the data accordingly, and then if they choose to, by selecting a value on cell B6, the table filters the information...

Hi I have been looking through the forum for a code to return all rows from every sheet in a workbook based on a two criteria match but without success. I would like a code that will return all rows, in all sheets, to a new sheet at the start of the workbook. Based on the criteria in two drop...

Hi Everyone, Struggling with three different scenarios; scenario one: if Column Row says "New" return "new", scenario two: if scenario one is true, but date is less than 2/1/2023 return "transfer", scenario three: if scenario one and two are true, if balance is greater than (>) past month...

I was wondering if there is a functionality in XLookup that can return all valid entries when the look-up is done on more than one criteria. Does Xlookup have the capability to 'spill' like the filter function do? Below is an example: I would like to display all returns for the two parameters...

I'm working on this bit of code which returns the first match as the result. Looking for some guidance or help to rewrite this to account for multiple matches - Criteria 2 is quite important as it changes later on in the data and needs to be accounted for (I feel I had to mention this as the...

Hi, this is my first time so I apologize for mistakes. I have already looked all over internet and have not manage to find an answer to fit my question. I have this set of data on sheet1 And I want to concatenate the IDs, Targets and DNS based on Name and Risk on Sheet2 like this So if it...

Hi, I am struggling to make Textjoin work with an additional criteria. =TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],RawData[Issue Status]="",""))) I am using the above code, which works, but then i want to use the same one, but adding an additional condition, which should be the below...

I apologise if this has been asked before but I can't seem to find an answer. I need the end result to be a discount given based on the product code, date range and quantity. For example: Based on the order date, product code, and quantity from the below table the discount should be -15.00...

Is there a non-array Index Match formula that references field names instead of specific columns and allows for multiple search criteria? Here is my original post that solves the "reference field names" function: Index Match / lookup formula using column names Can I expand on this approach to...

Hi there, I have a list of employee names, which are also accompanied by date and location information (see example). I would like to quantify how many relationships exist between the names on the same day/location. In other words, how many times has each employee worked with every other...

I have a data sheet that I would like to make a pivot table or another sheet off of with a specific customer number and then day of the week. Below is an example of some of the data. Column E is customer numbers. I would like to make a table or sheet using specific numbers from column E and...

Hello - I am trying to figure out how to create a message box that appears based on multiple criteria. I have tried doing research and still can not figure it out. I know minimal VBA, though I am confident it is possible. I currently have a workbook that my project manager enters his crews...

I am getting nth smallest value with multiple criteria but couldnt get the position of it. I need postition to lookup other values in the same row of the nth smallest I used the following formulas =IF(AK$2=0,"",IFERROR(SMALL(IF($K$4:$K$20=AK$2,$I$4:$I$20),$U$4:$U$20),"")) No issue with this...

Hi, I'm knew to this and would appreciate any help provided. I read somewhere that there is a limit to the number of terms that one macro could handle. I need a VBA script to delete multiple rows in column “A” based on if the cell has (ANY) reference of over 150 terms. For example, if I want...

Hello, I have data similar to whats shown in the "Orig Data' table. I would like to pull unique Names only, based on two criteria (Start Date <= today AND End Date >= today. I would also like the data sorted (oldest to newest) based on the Name's corresponding End Date . My goal is to have a...

Hi, I'm struggling with the below VBA. I have data In cells A6:S1176 and headings in cells A5:S5. I want to filter column A based on the value in B1. I then at the same time want to always filter out anything minus or below 0 in column G. When I run this macro though I get this error message...

Hello, I have a spreadsheet with the following 4 columns – Group,Type, Day Rate, Night Rate. Each row ofeach column has a drop down selection list. Based upon the selections made, I want the spreadsheet to populate theappropriate Day Rate and Night Rate. Data regarding the rates is in a...

Hi Team, I am using below macro to auto filter on col D and Col F on worksheet "confirms" with below criterias and then trying to copy col P and Col S filtered data to another worksheet names "Non=Cash Trades". the below code is autofiltering only col D with "N" and Col F with "COD" not "F/D"...