criteria

Hi, I need to make a GANTT schedule from the production with tanks etc. I cannot get the different formulas to work, when they do I will add it as conditional formatting in different colours. In D2 "Gannt Mrexcel.jpg" I want TRUE if C2 find a match in H:H "Raw data Mrexcel.jpg", also the date...

Since I am currently working on this project at work, I cannot post the data on this forum but I will try my best to explain the problem. I am looking to pull the top 20 dollar amounts from a range, based on an additional criterion. For example, one field contains either of two possible...

Hello: I plagiarized the following VBA from a YouTube video that I found, and it gives me exactly what I am needing...however it is missing a piece that I hope can be solved here. I would appreciate any help, and please know...I am not very strong in VBA (yet). I am needing to augment this code...

Hi all! I am trying to write VBA code to execute the following (visual screenshot attached) If the value in column C of the pivot worksheet isn't found within column G (specific to the material in column B), I need to update the qty in the Overview tab for the missing size to 0. For example...

I have a set of data that consists of one column of dates and another column of values that corresponds to the date next to it. I would like to have a formula that you can search for the lowest date based on the month and year. So if I have February and 2020 as the criteria, and the data is...

I receive a long list of data of people I want to contact, but want to filter out the people I don't want to contact. Each row (person) will have multiple columns, one of which could be "Location" [London, Paris, New York...] I have a list of blacklisted terms, for example [Paris, Cairo...

Hello all, I'm not sure is this is possible, everything I have looked at seems like it needs to be exact amount. I'm hoping someone can help. Please see image attached. In column B is the list of amounts I want to seperate into C D E F G columns. The total of £189,733.00 is divide by K6...

hi friends I have another addon to my sheet that im looking to sort. i would like to return a TRUE on each row where the =filter match exists (don't know how) against the criteria in col A here is an example sheet of what it will look like ABCDEFGHI1Not ideal.Wanting to do this2Hardcode list...

Hello I found this example (function) that makes all possible combinations of different ingredients, I want to add a condition that every ingredient can only be used in certain position ( column)... Any help would be much appreciated

Hello guys! Hope u are good! Could someone please help me with this code I'm trying to edit an reach my goal? Goal: copy rows from a Sheet1 to a Sheet2, that meet a criteria, with a Date and time record! for example, all rows that have yellow as text in the colum G of sheet one, after I click...

Hi Team, I'm facing the current scenario, I will start by placing the sheet that i'm working in and then bring up what has to be done: ABCDEFGHIJKL12UUIDWhatsover1Whatsover2Whatsover3Whatsover4Whatsover5Whatsover6Whatsover7Whatsover8Whatsover9Adjust and...

Sub copyT() Dim wrfrom As Worksheet Dim wrto As Worksheet Dim lastrw As Long Dim i As Integer Dim rng As Range Set wrfrom = Sheet1 Set wrto = Sheet5 lastrw = wrfrom.Cells(Rows.Count, 1).End(xlUp).Row wrfrom.Select For i = 2 To lastrw Set rng = Union(Range(Cells(i, 1), Cells(i, 6)), Cells(i...

Working on UDF to display the filter criteria for a table. UDF would be just above filtered table. Found perfect UDF but only works on normal filters, not table filters. Having trouble adapting it: Function Show_Criteria(Rng As Range) As String Dim str1 As String, str2 As String Dim tbl As...

Is it possible to find a row with 2 criteria? I'm importing survey anwsers to a worksheet, now I want to find the answers of a specified person I need to find the row in the worksheet(ImportLimesurvey) that has 2 specified cell values: In that row: the value of the C-cell has to be one of the...

I have the 2 tables below: Table1 ID Start Date End Date ABC123 01/04/2020 13/09/2020 DEF456 03/01/2020 17/02/2020 ABC123 15/09/2020 30/09/2020 Table2 ID Start Date End Date ABC123 17/12/2019 12/07/2020 ABC123 13/07/2020 11/11/2020 DEF456 07/07/2020 09/09/2020 DEF456...

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

Hi, This is my first post please be nice. I am creating a Windows 10 Excel 2016 document which takes a bulk data download on Tab 1 (5 rows, 70,000+ column entries), filters out around 10 words, filters in around 15 words (Keywords are Tab 2) and displays the filtered data (Tab 3) as 5 columns...

Hi guys! I have kind of a complex question. It all starts with a very large spreadsheet (let's call it 'raw data'). It has many columns of information (A:GD). Much of this data is pretty useless to me, to be honest. But there are a few pieces of information that I want to extract (if the row...

Hello, I am fairly new to vba and i am having a hard time coding something that will solve my issue :( I have two data sources I wish to combine. Sheet 1 Data source on Sheet1 contains 2 columns: AccountID and Cost. Source is in cells A3:B3 (data row starts in A4) for 1 to N records. A...

I'm trying to count how many distinct items appear across multiple columns with a single criteria from another column. My ability to use the right words might be keeping me from finding a solution on the web. Cities Restaurant 1 Unrelated information Restaurant 3 Unrelated Information...