1. O

    VBA To identify the non-match between a pivot table and a column of data

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

    Return date based on month and year from data

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

    Filter a list based on a list of terms, then copy filtered list into a new sheet

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

    EXCEL VBA or Formula: Split sets £ enteries based on criteria amount or close to it

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

    How to space =Filter by row and return TRUE

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

    Combine based on certain criteria

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

    Copy rows from one sheet to another that meet a given criteria?

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

    VBA - Layout and sorting with conditions

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

    Copying rows if criteria is met but only specific cells of the row

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

    Show Table Filter Criteria In Cell

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

    Find row with 2 criteria

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

    SQL Help - Duplicate IDs

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

    Counting Unique Dates within a Date Range With One Critieria (with Photos)

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

    Multi filter by word on Excel 2016 document

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

    Selective copying based on criteria

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

    Compare specific Column in two sheets and append data to last available 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...
  17. L

    Count Distinct Cells in Multiple Columns with Criteria

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

    Cell Formula to count first occurrence of a customer name with criteria

    Hi! First time poster! I am trying to use a formula field to determine a first occurrence of a contract being signed ( ('Order Items'!$A:$A) result as a "1") or ending (('Order Items'!$B:$B) result as a "-1") per a client name ('Order Items'!$J:$J), per month ('Order Items'!$O:$O), to be...
  19. A

    autofilter for dates by xlfiltervalues

    does any one know a location for the excel function by @Jon von der Heyden which displays AutoFilter criteria (including the date filter) in an Excel sheet
  20. I

    Copy rows in seperate worksheets to new worksheet based on date

    Hi, I've got a spreadsheet with 21 active worksheets. 1 of those is a home page and the other 20 all have data on regarding deliveries for my company. I want to make it so that Excel automatically searches for any deliveries >=TODAY on all the worksheets and copies those rows onto a new sheet...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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