partial

Hey all! I'm trying to search sentences with construction activities for a specific part of that sentence, and give the corresponding output. Here is an example from the file I am working on: Column A: <colgroup><col width="416" style="width:312pt"> </colgroup><tbody> LEVEL 04 - INSTALL...

I want to detect a part of string from a cell and then apply vlookup to get corresponding value from another table. Please refer below tables. Values are to be extracted from second table into first table: (there are also few spaces in first table in start of string) First Table...

Greetings! I am trying to get the following results in column B: Book1ABCD1ValuesException?Exceptions2JOHN SMITHUNIVERS3UNIVERSITY OF OHIO1STATE4UNIVERSIDAD DE COLUMBIA15JAMES JOHNSON6HOPKINS UNIVERSITY17STACY JONES8OHIO STATE1Sheet6 Basically, if the cell in column A matches any of the list...

Is it possible to write formulas to perform a "fuzzy lookup" without installing the addin? E.g. I have 2 columns with partial matches in the middle of each description, but varying numbers and texts before and after within the cell.

I apologize if this topic has come up before. I did search and read but I’m not entirely sure I’m using the appropriate terminology. If you are aware of a thread or solution please point me in the right direction. As per the wife, the details are a bit sketchy. She inherited this spreadsheet...

Hi I'm trying to use Vlookup to find just part of a text string in a cell. The formula below works OK for cells with small amounts of text (one line across the top) but doesn't work with larger cells. (Below is an example one of the large cells, this text is all in one cell on excel ie A3). On...

Hi all, just been racking my brain on this one for a while. I am trying to get an average of the last 6 months (from the previous month: ex: if it's November then May-October) of data in this list the only thing I can think of is a whole bunch of nested "IF(MONTH(TODAY())=11, AVERAGE(blah:blah...

Hello, I have a workbook with two sheets. One of them is updated monthly with a list of contracts and contract details. However, that sheet is generated automatically by an external program and is quite cluttered and difficult to navigate. My goal is to create a simplified list of every...

Hi everyone, I've been struggling to find a way to use a single formula to look for a text within a cell and, in another case, an exact match in that same cell. This is an example: Case 1= if A1 contains "red apples, apples, pears, grapes", value is TRUE Case 2= if A1 contains "red apples...

Hi All, I have a workbook with close to 150 sheets in it. Each sheet only has 2 columns, A = email address B = Active/Inactive member. What I am trying to do is search A for multiple different terms, highlighting cells that do not match a specific partial text. To explain it further - the...

I have sheet 1 with one column of values like this: <tbody> F14BLINKIN-DW F14BRAVE-DW F14JORJALG-DW </tbody> I have sheet 2 with 2 columns of values like this: <tbody> BLINKIN $125.00 Deeter $150.00 Lucy $130.00 </tbody> I need to make a column B in sheet 1 that grabs the $...

Hi All, I have a scenario where I have made a County/Country generator based upon an input cell's text (which in this case is partial Postcodes e.g. LU1, MK11...etc) using the formula =INDEX($A$2:$A$2873,MATCH(E2,$B$2:$B$2873,)) where $A$2:$A$2873 = List of Counties E2 = My input text cell...

Hello and thank you to all who reply. I need help with a trick situation. I am using Excel 2013 and I want to Countif any part of data in cell C1 matches data in range B:B. I have tried =COUNTIF(B:B, "*"&C2&"*") and it only counts exact matches. Please see the example data below: (I need the...

Hello everyone, I have an issue in excel 2010 where it will not fully paste the information I'm trying to copy/paste. Sometimes less than half the data is transferred over, as if it doesn't recognize the other pieces of data. (I'm copy/pasting in between workbooks, sheets, and directly from the...

HI, I am looking for a way to do a string search in a cell and print the 2nd part of the text in the cell. In cell [A1] i have value "TWD = 30.068323" and I want to a formula to return everything after "= ", so in this case, it should return value 30.068323. Can someone help me with this...

I am trying to get a formula that will return the following result. If column D shows "Out-of-School" anywhere in the cell, then I want to count the number of unique students that have a resolution stating "out-of-school". For this particular set of data there are 3 unique students that have a...

<tbody> I am trying to get a formula that will return the following result. If column B shows "Out-of-Town" any where in the cell, then I want to count the number of unique employees that are out-of-town at any time during that week. For this particular week there should be 2. The problem I...

I'm looking for a formula to: Column A - contains list of names. Column a has 1000+ values A1 : jjjj john jjj A2 : JOHN djfkdjf A3 : kdfjkdjf John A4 : sdslkdl dave A5 : ddsjkdave A6 : terry A7 : kjdkfjd Terry 030 Column C - contains lookup values (column c contains 50 values) C1 : john C2 ...

Hi all, Currently I have 2 columns of names of companies for which I currently use a VLOOKUP to find a yield percentage for said company, and input it in another column. For example in one sheet I would have the name of the company: Bob's fridges Then in another sheet I would have in 2...

Example of my problem: A1- 85,331.93 A2- 508,007.30 A3- 515,677.05 A4- 175,311.71 A5- 535,316.91 A6- 147,687.14 A7- 141,606.92 I need to use any combination of these numbers (including partials meaning I can use 60,000 from A1 and save the rest for later) to equal a a set of sums. For example...