partial

Hi all, I'm trying to get a formula to do exact and partial matches. I use INDEX(...MATCH(...)) to look for exact matches and if fails, then I try to do partial matches using VLOOKUP() but is not showing expected output. The partial match should show the "best match", this is select the...

Hi, I'm looking for a formula that allows me to search for a specific partial text that is part of a word, and then return the characters that start off the word. So for example, I have a cell with information like "English, Maths, Science, Community Skills, 45C/English, 3A/Maths, 5B/Science"...

Hi, I have a simple macro to copy-paste formula over a range of active rows. I've used Dim statement to identify the last active row using worksheet countA function. And then written statements to copy formula from a specific location and paste in a specific cell for the active number of rows...

I am trying to match partial text in a string with text from a range on another sheet. The text fragment in the string is usually found after the last comma. For example: P38 Some Noise Text > Other Noise Text > 12-3456, 7890 Text I Want The range on the other sheet (Sheet2!$B$2:$B$505) will...

I’m looking for help on how to conditionally format several worksheets in a workbook. Each worksheet already has a different type of conditional formatting in areas that I would not want affected by the new conditional formatting. I have two columns (A and B) with approximately 50,000 cells...

Problem: Trying to run an index match_partial match on a long column of values to return the desired result but have been getting an #NA. Current formula without changes: =INDEX(level,MATCH("*"&J3,title,0)) So I'm trying to match these values to return "Middle Management" for values that...

Hi I have a table of data with many rows an columns and I'm trying to count the number of records that meet numerous criteria. I've managed to get a lot of it to work but am stuck when it comes to one field that contains one or more partial string elements. My current formula is: -...

Hi Team, Need your help , in sumproduct formula, I want Count of Partial Match. and also how to use not Equal in Partial Match using wild Card. Below excel formula gives correct result. for Exact Match. Need some change in Third Criteria. highlighted in bold...

Hello Everyone, I was wondering if anyone might know how to return only partial data using Vlookup. I would like to only bring back the first name instead of the full name when doing my vlookup. Thank you for any help anyone can give me. Thank you. D.

Hi I'm using excel 2016, with data running down the columns Q,S,T it calculates items divided by hrs, but I'm stuck as i have partial hrs and this over inflates the value in T1, is there anyway i can make it more accurate say to the nearest 15 minutes also how do i remove #DIV/O! as my...

Hello, I am trying to pullup a customer# based on their name in cell D1. There can be many customers with similar names. I am looking for help to populate a drop down list which the user can select to get the exact match. The cell D1 is populated by a designer, who may use apostrophes...

Hi, I have a list of people in Column (A) followed by their home addresses in column (B). I would like to find a formula that will look at ONLY column B and highlight any cells that contain partial matches of home addresses to another cell in the same column B. I only find formulas that work if...

I need to SUM a range where some of the cells contain partial text as below: 5 6 2 L5 4 SUM should be 22 taking the digit from second last cell also.

I want to assign a category to a table so that I can eventually create a pivot table. I need to do a partial match to get my category values. "num" i want to match to "number 111" and "numeric 321" and then assign both of those as category1. "form" i want to match to "Form 1" and "formula" as...

Hello, I would like to know if there is a way to protect partial rows and columns. As an example, I have a spreadsheet that has data in Columns A - F and through Row 3. I don't want that data to be editable except via a password. However, I would like a user to be able to add more columns after...

Hi, we need to do a “reverse partial lookup”. i.e. we have a list of old_product_codes (Col A) and new_product_codes (col B). And we need to know if any of the new_product_codes contain (or equal) any of the old_product_codes We have found ways of making this work on smaller lists, but we...

Hi all, great to be here in the community ad thanks for having me. I am basically wanting some VBA code that can be used as a macro to open a find box, then input either a partial text or partial number. This in turn then searches specific worksheets (example worksheets: MON01, MON02) of which I...

Hi all, I have a problem in issue the products on the basis of PO wise ( PO means purchased order issue by Hospital with all term and condition QTY, PRICE ,Supply, etc. ). We can’t serve complete PO qty on a one day with different reason but issue to hospital on demand basis. There is a problem...

Hello. Please refer the attachment. The Data List is in column A with multiple words in a single string in each cell A14:A17 Column A (starting at A13) <tbody> Data List JohnMarySue SueJoeNathan KellyBobThomas ShaunSisterMale </tbody> The Filter list of unique words are in F1:F10...

I posted here and got some help, but not exactly what I need: https://www.excelforum.com/excel-general/1248831-dynamicaly-linked-cells-based-on-the-month.html#post4989975 I will do my best to explain what I need My company went to a monthly calendar reporting period with 12 reporting periods...