1. J

    If Two cells match, output two values

    Hello, I would like to look in a range to see if two ranks match, if they do I would like excel to output both team names into two separate cells. For example in my image I would like to get Team 1 and Team 2 as my output but separate cells. I believe I need an array formula? but I cannot...
  2. D

    Get last 2 non blank values of a row

    Hi, I am trying to make a column to obtain last values that were added in some table. Each month table expands so new values are added... So far, I managed to get the way to obtain last value, last value -1 and last value -2 (so I'm having last 3 values in other words). My problem comes when...
  3. Y

    Index Match on a random string, multiple possible criteria, results

    I have a huge list of accounting entry descriptions (all are unique and hand typed) that need to be examined to determine treatment (1 of 3 possibilities). I built a keyword finder using IFERROR(INDEX(MATCH(ISNUMBER)))) that works great. It leverages a 2 column table with keywords and their...
  4. S

    Custom VBA Dictionary Solution

    Searching for a custom VBA dictionary code, for a massive workbook, containing two worksheets, sheet1 (Release) containing +40K rows, sheet 2 (Resource) containing +185k rows. I realize that any VBA macro will take a long time to execute this command–given the amount of data, that’s okay with me...
  5. S

    Looking to compare 2 Column and find closest match then sort

    hello , I have this 2 list ,and I want the same word to be in the same row ( Ex : row 1 contains : "Service 351" in A1 and "Service 82" in B1 ) , please help and ty ♥
  6. R

    Match error But there is a match as a fact

    I have a table with several columns as shown below. The issue is that I must do a search for a number entered manually. The search must be done in a column that results from multiplying the value $ by 100. With some values, inexplicably, the result of the formula +MATCH(I;$H$4:$H $164;0 ) is...
  7. T

    Resetting Row Counter Loop?

    I have this code here that copies, and pastes from one sheet to another if the match is not found. However, I cant seem to get the row counter to reset to the top of the row. Once it is done looping through a row, it should reset to the second row (as the first row will be a header row)...
  8. Jyggalag

    Create slicer for a list without pivot table?

    Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...
  9. 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...
  10. P

    2D Match - Index and Match with more tha one row.

    Hi, I am looking for a way to use a lookup values to match the Chemical concentration with its respective Sample#: For Chemical 1 to 9 I don't have a problem, I can easily use 2D lookup Match& Index. However, for Chemical 10 and Chemical 11 this won't work as there are several rows. I could...
  11. D

    Condition a cell result based on rows value

    Hi all, I'm struggling to make a condition to a value to show a result based on the value of rows below in the same column. The idea is to give either R, A or G result, based on what is below. So if i have X amount of rows below, and each one has different values in combinations of R, A...
  12. Jyggalag

    How do you make VBA code run automatically?

    Hi all, I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why? Thank you!
  13. C

    Substitute for Arrays in Excel Online (specifically Index/Match function)?

    Hi, I have created an Excel Online workbook that I am using with Power Automate in order to pull in Survey123 results (results go into a "RAW DATA" tab). In my "SUMMARY" tab, I am presenting an overview of the Sump data by date. In order to pull specific data from the "RAW DATA" tab and match...
  14. P

    How to count the most commonly occurring text, while excluding a certain phrase?

    Hello, I'm looking for a formula to return the most commonly occurring text in a range minus a specific phrase. Is there anything I can add somewhere into the formula I already have, which returns the most commonly occurring text? Or do I need to rewrite what I already have? Here's what I have...
  15. R

    Index Match multiple results skip the blanks

    Hi there hope someone can help as I am about to lose it because I know there is something simple. I have a table and I need another sheet to return only cells that match 2 given criteria and aren't empty. I have 2 worksheets and need the information from worksheet 2 to show up on worksheet 1...
  16. H

    Look up a value based on header criteria - help!

    Hello, I am looking for a particular function or set of functions that will allow me to display data on a "summary" tab in excel. The context for the data that I am dealing with is listed below: I have multiple values from different regions that differ each month, what I would like to do is...
  17. T

    How to list and compare locations of non-matches in other sheets?

    Hi everyone, I need a VBA code that can compare a master list to lists in other sheets (could be an unlimited amount of sheets), and highlight the locations of the the non-matches and take the users to those locations. For example, if on the master list it says apple, and on sheet 2 column a it...
  18. Jyggalag

    Create overview list that pulls in data from downloaded sheet

    Hi all, I am currently downloading a bunch of sheets that look like this: I would like to make an overview in my sheet called "List", where the data from "Sheet1" is automatically pulled in. However, I would like to do this without making any changes to the downloaded sheet, including not...
  19. Jyggalag

    IndexMatch formula based on name of Excel Sheet

    Hi all, I currently have this setup: Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0)) My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now. I want my formula to pull in data based on the value in column...
  20. O

    Matching concatenated values across columns VBA

    Hi there! I am trying to write VBA code to execute the following (visual screenshot attached) If the concatenated store and zip code value (ex: Walmart98101) is repeated in any of the columns (ex: columns C, E and F), I need to ensure the value of row 1 is the same in each instance of the...
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