matched

Hi all. I have the following formula. the only problem is that there are 4 criteria and all of them have the word Matched in the options. I need a formula (which this one does all but the last part) that is dynamic to filtered data by counting the visible cells only that meet an exact text...

Note: having problems making the data look like an Excel chart... hopefully it's clearer than mud :-) Thanks in advance for your help! I'm not sure if this is a match, index, vlookup? But I'm guessing it's pretty simple to do. I'm looking for a formula that will do the following: Match the...

Hi Team, I am looking for vba syntax here to count visible cells after filtering data Status column should be unmatched, below are Criteria. 1) Count trade age less than <2 , Result Sheet2.range("b5") 2) Count Greater than >2 & <=3 , sheet2.range("b6") 3) Count Greater than >3 ...

So I think I need an if statement but I cannot seem to make it work but here is my problem (hopefully I can explain it well enough) Colum A is a number (meters squared of work completed) Colum B is size of rock used (naming convention used through drop down box being used a total of 5...

I'm not even sure where to begin on this one. Lets say I have 2 columns of matched numerical data (A1 and B1) in tab1 (ID number and score). In tab2 I have a column with all of the data from A1 (A2) plus approximately 10% more rows of data that are not in A1 from the original tab. I also have...

I have an IF formula I've been using that uses EXACT function in it, so anytime something was in CAPS and it matched a cell it would come back with a 2. If it matched but wasn't caps it would be 1. Then those numbers would be tallied. I wanted to see if maybe there was another array I could...

Hi all, I need some help. I have 2 workbooks, one (results.xlsm) with SKUs in Column A, and I would like keywords I have for them put into Column B. The 2nd workbook (keywords.xls) has some SKUs in Column A, and corresponding keywords in Column B. I would like to use some VBA to match SKUs...

Hi everybody, How it is possible in Power Query to partially search if a value in one dataset exists in the second one. I want to replace this approach: if Text.Contains([Column in 2nd Dataset], "Keyword 1") or Text.Contains([Column in 2nd Dataset], "Keyword 2") or...

Hi, I am not trying to compare the right to the left, I am trying to compare two lists completely and find whats missing going left to right and right to left and produce a new list of data that is not matched. I tried using this formula but I am only getting a false value. I also want to...

hello! I have 2 worksbooks and i need to compare one column from workbook1 with another column from workbook2 and then I need to put the non-matched data into workbook3. Is it difficult to do in a macro? i dont have an idea to do that :( thanks for your help...

Hi, I need a one formula solution to compare two columns for duplicates and count the number of matched pairs. Need to ingore blanks. Can have matched numbers or letters. Asterik denotes a blank (empty) cell. Also only consider the first matched pair if there are more than one matched...