(All EXCEL.LENT ladies and gentlemen)
I have text in Column A.
Here are the rows of the table that start with the following characters:
For example: <A1 S = "20" D = "5.70" Z = "15.68" Date = "2021-03-25" F = "1000615" Abj = "DE09876547" />
Then the lines follow
Column A contains strings
Column D Contains a list of words to search for
Column B returns true if whole word found
Only return true if whole word is found eg Dog not DogD
If not in list return a null cell
If possible I would a more detailed result
Column A contains strings
Each day I get in a bank statement, and on there I need to search within the reference column for specific text in the form of invoice numbers. but to get around the fact the invoice numbers and letters are different, I want to make a table with these values in, but have wildcards in between...
I've got three formulae that work in isolation, but not together.
If the text "4 for 10" is in cell A1, I'd like one formula that returns the text "Multi deal where X<Y" if 4 is greater than 10, which it is. But returns "Multi deal where X>Y"if the text in cell A2 was 10 for 4.
I have data where the word "for" will appear in cells and if two numbers in the cell are the same, then I'd want to return the word "volume" and if the first number is bigger than the second, then I'd want to return the word "value"
To give a simple example, let's assume that
3 for 3...
I need to determine if the individual cells in column A (A1:A17933) contain text from any of the cells in column C (C1:C1957), and if so, return the column C cell's corresponding value in column D (D1:D1957) to the column B cell next to the column A cell containing the column C cell text.
I have been using the VBA program on Excel 2010, Windows 7 below but I would like to change it from searching one number to one set of numbers (see my notes below) entered in cell C17. Can this program be used for that purpose? Wondering if someone could look at it and provide any feedback...
I need some help with creating a loop macro, hope someone would be so kind and help me
i need to search all cells in a range (b2:y200)
if a value (value would be a name - so text) is found, i would like to go to sheet ("data") find the value in range (B2:B100) and copy the cell to the...
I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category>
I am using this formula. But keep getting an #NA...
This is the formula I'm attempting to use (which, I have used in the past and no issues):
=IF(ISNUMBER(SEARCH("Sport Slotted - GM - 126.62092SL","Slotted")), "Yes", "No")
This Always returns NO unless I put the whole search string as "Sport Slotted - GM - 126.62092SL", which defeats the whole...