1. G

    How to filter a table with two email columns against a list of emails

    Hello! This sounds so basic, but I swear I've searched for a long time and can't find exactly what I need. I have a list of (usually thousands of) contacts with multiple columns (E.g., let's simplify to: first name, last name, personal email, work email, phone) that I need to clean against...
  2. S

    GSheet issue, need to lookup a value from 1 tab to another tab, and return multiple values from one column

    Hi all, I have a GSheet with two tabs 'Sheet 1' and 'Raw Data'. I need to Look up an 'Opportunity Number' from Sheet One (column A) and find this in 'Raw Data Tab' (Column A) and Return Multiple 'Partners' from 'Raw Data tab' (Column B). Please see attached Mini-Sheet, I need the results in...
  3. K

    Fill by matching and adding rows for multiple matches

    Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...
  4. K

    Index/Match multiple hits of same cell value and add rows to fit spill

    Hi guys! Not sure how to approach this - with lookup and aggregate, an index/match sub or something else. So In the sheet called Empty, when B2 is filled, it populates the Invoice column in D4:D with unique invoice numbers from an external order sheet. The Sales sheet has a list of orders where...
  5. D

    multiple replication

    Hello The dates should repeat exactly after the red arrow sign. please help.
  6. R

    Match data in one excel sheet from another sheet including duplicate values.

    In the first image in column F I have name of customers, and in column K I have deposited amount (here are multiple amounts which are similar). In the 2nd image, in column E I have received amount of amount and in Column H I want to input names of customer based on the data of Column F in Image...
  7. 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...
  8. W

    Rank by group (3 columns)

    Hi all, I have read a lot of the forums to related about rank by multiple criteria, but I still not work for me. I would like to rank by value sales (column F) based on Shop, Category and Period. I have already input the expected rank in last column, please kindly help me to solve this...
  9. A

    Append/Consolidate Multiple Workbooks with Multiple Sheets retaining the Format

    Excel warriors, I have 38 xlsx files stored in one folder. Each file has a different count of sheets (15+)—all sheets have the same column count, same headings, but different counts of rows. I need a macro to append (consolidate) all of the sheets into one sheet in a new workbook. This...
  10. M

    Get unique values from one column from all spreadsheets in a folder and copy to a new spreadsheet

    Hi, I have anywhere from 60-100 spreadsheets generated from a reporting process in a folder. Each spreadsheet has set number of columns (A through G). Column G (Notes) is used by end-users to put notes. I am working on creating a unique list of all these notes from all the spreadsheets in the...
  11. C

    Count Words in cell and ignore blanks

    Hello, I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example: Source: Genre Number Historical...
  12. M

    VBA code to extract unique data across multiple sheets and multiple columns

    Hi everyone, I'm searching the web but I only found one code that kind of works but I need to make it more complex. Let me explain. My issue is that I have an Excel sheet with multiple worksheets, which all contain the same kind of information but are copied weekly by me. So every week, I will...
  13. H

    Index/Match values for multiple possible matches

    I have a list of employees and their course assignments, a list of employees and their certifications, and a list of the required certifications for each course. I am trying to run a single cell check on whether the person is appropriately certified for a assignment based on the range of...
  14. A

    Macro to delete every n+1 row across all worksheets

    Please the number of first rows to be deleted INCREASES along with the worksheet numbers. For example, row 1 (first row) would be deleted in sheet 1, row 1 and row 2 would be deleted in subsequent sheet 2, row 1 row 2 row 3 would be deleted in subsequent sheet 3, and so on. Please any help on a...
  15. C

    Sum Multiple Row and Column with Condition

    Hey there, I have two sheets on hand, and need to sum the multiple results in condition at the third sheet. Are there anyone can tell me the formula that can achieve it? Thanks! Here's what I have: Sheet 1 Sheet 2 And here's what I want: Sheet 3
  16. P

    INDEX MATCH with multiple matches

    I've been working on this for a while now without any luck, so I thought it might be time I asked the experts. I have 2 workbooks: Workbook 1: Raw postcode data only in column A Workbook 2 (Index): Postcodes (column A) with all localities affiliated with those postcodes (Column B). Note that...
  17. B

    Rename multiple Worksheets by a cell value (Date)

    Hi all, I tried to google a day to solve this issue but it did not work. Can anyone help me to give me a solution, please? How can I rename multiple worksheets (from sheet2) from a column value (Date) as the photo attached by using VBA code? Thank you.
  18. C

    If & Concatenate Multiple Fields

    I am trying to concatenate multiple fields if there is data there. G2 is what I want the data to look like, only picking up the cells with data and concatenate with the heading with + between each fields.. I managed to only get one cell and header =IF(A2="No","",CONCATENATE(TEXT(B2,$###K"),"...
  19. R

    Fill cells based on data in another workbook

    Hi all hopefully someone may be able to help i have a 6 workbooks.1-5 contain the data from the different offices about the times they are working. I import the data into workbook 6 onto different worksheets. i displaythem in a Gnatt style chart which i have created using the following Formula...
  20. J

    Macro to keep track of username and time for users who opens an excel file

    Dear Team, I have got a macro in an excel file which tracks the username and time of the users opening the file which I definitely need. The problem is that if 1 user opens the file and leaves it open then it doesn't track the name/time of other users who open the file when its in use. Is it...

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