index

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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!
  6. 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...
  7. 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...
  8. 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...
  9. B

    Find more recurring text in same column but skip specific cells?

    Hi there! I made a spreadsheet and I'm trying to have it autocalculate data, but I'm looking to find the most often recurring text values. This spreadsheet is broken down by month and I'm trying to have one box give a "running total" for the year as the user fills in the data, but obviously we...
  10. M

    Index Match Match with a loop

    Hello all, New to the thread so I do apologies if this isn't sufficient. I am trying to create VBA code for Index Match Match with a loop. I have attached an image to help. To detail the problem; - Cells A4:C13 have permutations from myarray (1,2,3,4,7) where I want 3 numbers picked and...
  11. 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...
  12. 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...
  13. Jyggalag

    Get formula that pulls a number from a sentence in a cell

    Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...
  14. B

    If column A and B have a match then multiply column C with D

    Hey guys I seem to be stumped! I have a spreadsheet and I am trying to get a value in an individual cell based on two rows of data on two different tabs and then multiply by another row of data :oops: Sheet 1 has column A, 63 lines with numbers column B, 63 lines with numbers Sheet 2 has...
  15. L

    Any suggestions? Need to lookup a value in a table and if True for multiple columns, create a new line with each result of true.

    As an example, need to lookup x in a table and pull in all results of TRUE but one at a time and each in a separate row. Need to get into format similar to below X TRUE X TRUE Value #2 X TRUE Value #3 Y TRUE Y TRUE Value #2 From a reference table in format: X TRUE TRUE Value #2 TRUE Value #3...
  16. F

    How to perform Index-match with great amount of rows (formula or VBA)

    Hi everyone. I hope y're all fine. I have a spreedsheet with prices for many products, according with the 4 criteria bellow: (1) City (2) Seller (3) Date (4) Product type Each product has a product "below" which price must be lower. So for example, the product B must be more...
  17. L

    2 Column Dropdown List That Must Match Dependent on Selection.

    Hi All, I currently have a PO tracking sheet which requires both The vendor name and vendor id to be present on the sheet for each recorded purchase order. What I am looking to accomplish is having users be able to make a selection from whichever column and have the corresponding data...
  18. P

    VBA Transpose and Move to a table

    Good Afternoon, This is a sample Profit and loss report by customer in Excel. What I am looking to do is take row 5 (That being the Job Names) and put the "Total Expenses" and "Total Other Expenses" into a table. My issue is that I will not know how large the sheet is, so I will need...
  19. S

    Index match with multiple criteria in a table

    Hi, Please see the picture attached. For every number in the left column I am trying to match that number and the property type found in the row next to it and return the associated number at the top. So for example for 103 0 06 with property type house-Y i want it to return 0. Note that I want...
  20. Jyggalag

    Change my VBA code so it sends pdf file instead of excel file

    Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...
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 MrExcel.com.
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 "mrexcel.com".
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
Top