1. A

    comparing 2 excel columns and filtering duplicates

    Hi, I have two sets of data, one is a column with a certain set of numbers, lets say 11111 33333 55555 Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this: 11111 abc 22222 def 33333 ghi...
  2. S

    matching of data to not match the same data again

    So currently I got multiple guys name john in my excel, how do I ensure that my vba doesn't go through the same cell over and over again? this the code I'm working with Sub match_Data() Dim rSH As Worksheet Dim sSh As Worksheet Set rSH = ThisWorkbook.Sheets("Master") Set sSh =...
  3. B

    Wildcard solution maybe??

    Each week I have to scan a changing list of names that includes former students. I want to find each student listed. My problem is that the list is outside my control and sometimes students names are presented differently depending on who creates that weekly list. Often Thomas becomes Tom...
  4. Tosborn

    Cleaning up messy data from PDF report, need to match up purchase order numbers with supplier names on 2 separate rows

    The messy data looks like the list in columns A & B (see image), the finished list needs to be like columns D&E. I'm cleaning up some very messy data with formulas on the spreadsheet up to this point but the solution could be with VBA also, I'm open to either. So basically the purchase order...
  5. M

    Reading from a table in Excel

    Hello All, If anyone knows how I have a large data set and I would like to check there is duplicates. Issue is there are two parameters needed to confirm this. So for example I have in Cell B3 the Activity ID “BLH7895“ and in Cell C3 I have the Activity Name “Taking out the trash”. How would I...
  6. S

    Match column headers and copy over data

    I am starting a new project to simplify an uploading process. I would like to create a workbook that is set up like this: Two sheets, one is called “Upload Data”, and the other is called “Prepared File. The “Prepared File” sheet has the column headers in the correct order for the upload to work...
  7. N

    SUM of amounts in one report to match with SUM of amounts in other report VBA

    I have 2 sheets - "AE" Sheet (representing "Day" & "AE" columns below) and "TC" Sheet (rep "Date" & "TC" columns Below). I need to do matching of both sheets. With the VBA code below, I was able to perform the ff matching procedures 1.) Single amount matching 1:1 and 2.) Single to Combination...
  8. F

    How to find matching values

    Hi All, I have a data of all positive and negative values like -400 200 200 -100 100 -500 250 250 300 -150 -150 I have multiple formulas to identify the matching numbers but all i want is modifications I have data in A1:A100 I use the B1...
  9. G

    Help with Userform MsgBox

    Hi everyone, I have a userform that has 2 textboxes to add data to a worksheet, this all works fine although i would like it to also search a worksheet called "Members" for a matching value entered into my first textbox called "txtMemFirst" if no matching name is found then it needs to show a...
  10. A

    Adding info from one sheet to another by matching vendor numbers

    I have two sheets of data. One is vendor payments, the other general vendor data from their master file. I need to add their federal tax id to the vendor payment sheet by matching the vendor numbers on each sheet. What’s the best way to do this?
  11. S

    Matching cells and creating a new worksheet

    Hello Excel Experts, I have 2 Excel files, the first has cells with the following data: [Name] [Cost] [Date] The second file has: [Name] [SKU] [Serial Numbers (can be more than 1)] I'm trying to combine these into a new file with: [Name] [SKU] [Serial Numbers] [Cost], based on the...
  12. B

    Find matching number for the result

    Hello All, I encountered a situation that I need your help with a formula to get the result as shown “result” range row J1:X1. The calculation based on weekly updated table on the left. If found a MATCH number from the “numberID” row J2:X2 in the Category row “A, B, L1A, L2UA, and T” , then...
  13. H

    Len if and

    Hi I have set-up the below but the LEN calculation seems wrong as LEN that isn't 15 is matching and doing the workday function. Can anyone see what is wrong please?
  14. S

    Create Sheet to index scores for a club

    Good day All, I need to extract data from an excel sheet and index them on another sheet to formulate results with handicaps etc. I am struggling on extracting the data: <tbody> Division Stage Number Name Hit Factor Classic 1 Ira 2.57 Classic 2 Ira 0.97 Standard 1 Jason 5.36 Standard...
  15. S

    Loop through 2 columns and and return TRUE or FALSE if adjscent cells are matching.

    Hi lads, Need formula in cell E1 that loops through Columns A & C and if cell value is identical i.e. AB1234X vs AB1234X then it need to compare corresponding adjscent cell values in column B & D to see if they are matching. If they are matching then it needs to return TRUE if not matching then...
  16. G

    VBA UserForm - Using TextBox to look up in a range

    I have a userform that when it runs comes up with a blank text box. I want the user to be able to type in the value that they want to lookup, in this case it is a box size, and once they press enter I need it to put all the matching information on the same sheet that I have my macro button that...
  17. D

    Formula to Check Matches

    I thought this would be simple however, I am finding more difficult than I originally thought. I'll try and keep it simple. I have a single workbook with multiple sheets with data. I am needing a formula to check column A on sheet #1 to columns A,B, and C on sheets #2 and #3 . If the numbers...
  18. B

    Matching formula that is too hard for me!

    Hi everyone, Here are the things that are in each column. Column A - Phone Numbers Column B - Dates Column C - Dates Column D - Record ID's Column E - BLANK Column F - Dates Column G - Phone Numbers I'm trying to write a matching or lookup formula that looks up and down these columns and...
  19. T

    reference cell

    I am looking for a formula. Sheet 1 I have a number in A:1, so in A:2 I need a formula that looks at the number in Sheet 1 A:1, then finds that number on Sheet 2 Column A, When it finds the matching number it displays the new number located in Sheet 2 Column B next to the matching number.
  20. K

    What formula should I be using for this?

    Hi all. I am really rusty on excel so I suspect there is an easy answer to this question, but it currently eludes me. Hopefully I can at least explain what I am trying to do! If sheet 1, cell a2 matches and cell in sheet 2, range a:a then display the matching contents in range c:c (same row...
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