phrase

Hello, I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example: Source: Genre Number Historical...

Akuini submitted a new Excel article: VBA Macro to create Word & Phrase Frequency - VBA Macro to create Word & Phrase Frequency Read more about this Excel article...

This macro generates word & phrase frequency. You can set the number of words contained in a phrase as needed, in this part: Const sNumber As String = "1,2,3" You can also set what characters should be considered as word characters, in this part: Const xPattern As String = "A-Z0-9_'" but...

Hello, I have a very large database of items of different names and descriptions. Some items are similar to others (ie: cable type X, blue, 3ft or cable type X, green, 9ft, or heat shrink sleeve,clear,55cm or main wire assembly,mft,out) I have been browsing around online (including other...

So first things first, my title might be inaccurate but I'm not sure of the terminology. I have a long list within a single column of various length text. Most of these text strings will contain, in part, 1 of about 30 known phrases. In the column next to the original text I'd like to place the...

Hey all! I'm sure this is an easy one, but I'm not very familiar with VBA. Essentially I'm trying to hide a submit button until one of the two selections are made from a drop down in I8. The below works for one phrase, but I can't figure out how to add another phrase to it. I want it so if...

Hello everyone! I have something I am working on but its driving me a little bats at the moment and I am hoping someone can help. I have a spreadsheet with two columns. Each column has a list of keywords in it. I am trying to compare column 2 against column 1 and place the unique keywords into...

Hello, I am trying to figure out a formula which will search a column for a phrase and if that phrase is present then display a number. any help would be appreciated

Hello, I’m trying to figure out a formula which will search a sheet for a phrase and then display the number which will be two cells below? Any help would be appreciated Thanks

Hello, I am trying to figure out a formula which will search a separate sheet for four different phases. Then, display the one phrase that is in the sheet. I need to search the exact phrase and the cells it is search will only contain that phrase ( i.e. I’m not search a paragraph of text) I...

Hello to all, I am new to the if statement and vlookup world and have been using A very simple if statement with great results =if(d22=0,(0),(c22)) Yes, simple but I like what it does and look to expand. I have a wb with a number of sheets. I want to place an if /vlookup statement in the...

Let's say I have this text in a cell, and I want to count all the words from word 1 to the first occurance of the phrase "Thank you": "The quick brown fox jumped over the fence to say Hello. Thank you The blue car was parked on the street and ..." The result is 11. This works great for an...

Hello all, I am trying to automate a report that is run daily so I think I have to use VBA so it does not have to be touched. What I'm trying to figure out to do is for each instance in a row where I see "SA" in column J, I need the phrase "Load" to populate in every row in column O. Also if...

Hi All, Have a question as to how I can go about creating a phrase in 1 column based on a keyword in a different column. For example, if a number in the range of 500-750 Appears in column C, I need “do not instruct” in column Obut only on those rows in which the range is >= 500 and <=750. I...

Hi from partially cloudy 9 Degrees C York UK, I am struggling with conditional formatting. This is what i want to achieve.. Phrase "Hotels York" - Wk 1 Position 5 | Wk 2 Position 1 - (Promotion Green Arrow Up) Phrase "Bed & Breakfast York" - Wk 1 Position 2 | Wk 2 Position 2 - ( No movement...

I use this website regularly and absolutely love the contentand presentation and always learn a new thing or two. I thought I would be able to write the formulas I need formy unique situation by browsing the Message Board and Learn Excel Resources,and even a Google search or 25, but to no...

Firstly many thanks for taking the time to read. In cell K2 I want to count the number of times the phrase “Grade 7” appears in column M8:M200 but at the same time if this phrase appears in column M I need column R8:R200 populated with the word “Yes” and “No” if it doesn’t. Most grateful for...

Hey all: I need help figuring out how to auto populate a cell based on a phrase or text in another. So, for example: If I put 'Replace VCT in doorway' in A1, I would like 'TWO' to automatically appear in B1. Would it be easier for me to do this in Access and then export it to excel? Either...

I have a cell containing a paragraph of text. When I go to underline a portion of that text, only the words are underlined and not the spaces. Is there a way to underline the entire phrase instead of just the words? What it does: The quick brown fox ran and jumped over the white fence. What I...

Hello, does anybody know how I can count the number of times each unique phrase in row "A" is repeated? For example if my data set was Blue Green Black Green Red Red Red Red Hat how can I get excel to count the number of times and return data like Blue 1 Green 2 Black 1...