matches

I have 2 files. FileA contains the item names. FileB contains a list of keywords. I need a formula that I can use on FileA on the second column that will scan all the keywords listed in FileB and put "1" if it matches and 0 if it doesn't match. I really need help on this. I need it for work...

I need to sum where criteria is matched in 2 columns and 1 row: <tbody> O P 2016 2017 2018 A * 2 4 5 A 1 2 3 A * 3 3 5 </tbody> <strike></strike> Using the example above, I need to sum if column O matches ‘A’, column P matches ‘*’ and the first row matches ‘2017’. So the answer I...

I am using the following solution: =IF(ISNUMBER(FIND("GRB2",B9,1))=TRUE,"FLS2",IF(ISNUMBER(FIND("GRB",B9,1))=TRUE,"FLS",IF(ISNUMBER(FIND("#billing",B9,1))=TRUE,"#billing","None"))) This is looking at a cell where I have concatenated the value(s) of 10 columns (V-AE). From that grouping I want...

Hi, I'm completely new to macros and sadly all my success to date is via Google, trial and much error. So I'd be grateful for anyone's assistance. The situation is this: I have a worksheet in workbook 1 that contains names and phone numbers split across different columns. I have workbook 2 that...

Hello All- The below formula gives me a check mark(W867), if cell G11 matches "O_P". I am having issues with the second part of the formula - I wanted a check mark also if G19 matches "PWS_LOG_WARE", if not "". =IF(ISNA(MATCH(G11,O_P,0)),"",IF(ISNA(MATCH(G19,PWS_LOG_WARE,0)),W867,"")) Please help

Can someone show me how to adapt this code so that it only copies unique values where the cell in column C matches the value of Sheet4 E2? LastRow = Sheet7.Cells(Rows.Count, "A").End(xlUp).Row Sheet7.Range("D3:D" & LastRow).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheet4.Range("E4")...

Hi, I think I am almost there but need some help with a vlookup that has multiple matches and I would like to return all matches. I am trying to return all email addresses matching a customer account number. My problem is that the current formula only returns matches 1 and 2, but does not...

This is my first time posting something here, hoping to get some help with my worksheet. I've tried several different formuals and combinations, however keeps resulting in errors. Here's what I want: If the header from a table matches the value of column A in a specific table then the value in...

I have two worksheets that I need to find where 3 cells within the row match. The cells that I need to match are CODE, ID, and DATE. I have a master sheet that displays all consumers information and another one that is detailed to a specific demographic. In the master sheet the columns are P, X...

Hi, Is there a formula I can use to pick up/return all matches when a Vlookup is used rather than just the first correct match. If I have data in column A and B, and 4 matches for the identifier on column A how can I capture all 4 matches?. Note the matches are email addresses....so column A is...

Hello, I have survived this far on trolling through forums to get the answers I need, but the time has come to ask the questions myself! I have a formula which lists all matches based on 3 criteria. {=IFERROR(INDEX('Drop Downs'!$U$2:$U$30790,(SMALL(IF(('Drop...

I have an excel sheet with about 10000 rows of numbers. 10 different numbers, all integers between 1 and 99 Every day I get a 10 numbers that should be compared to the existing rows and a result written out in new cell after each row how many matches there are. Is this possible? I am new to...

I need a formula to count the number of matches between two ranges even some numbers repeat itself. For example, if in row1 ( 1,1,1,3,3,4,2,8) and row2(1,2,3,4,5,5,7,7). Here there are 4 unique numbers match (1,2,3,4). But with repeating numbers, it is actually 7 numbers (1,1,1,3,3,2,4). I need...

Hi, I hope someone can help me out on this one. I've searched Google, this Board, but I just can't seem to get it to work. Below is my table. The trick here is that the Values in Column B, can be matched several times to values in Column A. I started with a simple index, match and that was...

Hello, I have 222 columns of data in one table that I need to compare to another. What I want it to do is: Highlight in Green if it matches and Red if it doesn't. Basically a report is "Exported" from software and pasted into the excel file into the tab "ChExport" Then I want to run a...

I want an cell to be highlighted if it matches any entry in a certain list. I was thinking I could do it with a MATCH formula, but I can't get it to work. Any help would be awesome!

(please dont delete this thread, i cant think of a better title) hi everyone, i have strings (each cell contains) like this: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>WW098-ZK-TRXF-PAB-MRX-01 <style...

Down Column H on Sheet 1 I have hours. This is the column I want to sum by. I have three criteria's I am trying to match. Where Column U on Sheet 1 Matches A1, Where Column Y and Matches B1 Where Column Z matches C1 (My formula is in Sheet 2 D1) I tried SumIfs but am getting errors. Should...

I have 4 columns of numbers (up to 8 characters longer) and I am looking to compare each cell (per individual row) up to 6 characters and result back the number of cells that match. If all 4 cells match I would like it to read "4 matches", if only 3 of the 4 match result should say "3 matches"...