dog

Hello all, formula needed for the following please if you can help A1 B1 D1 E1 Dog fido Dog 4 dog jess Cat 3 dog rover dog max cat...

I'm sure that this is already plenty of threads for this, but I'm not sure how to explain what I wish to achieve. Currently I have a list which has a description in. I want this referenced in another table, however I want all the descriptions which match to be grouped together. For example...

I’m struggling to modify this code (below) to handle fuzzy matches, e.g., treating words like dog, dogs, Dog, and Dogs the same. Any suggestion as to how I can modify this code to do this? ———— Function Count_Positives(Sentence As String, Positive_Words As Range) Dim Counter As Integer For x =...

Hi, I have a series of data running across a number of columns. Where a certain word appears in the data, I am wanting to colour fill the 3 cells to the left of it. Using the below example, where the word Dog appears, I would like the 3 cells to the left of the cell containing the word Dog to...

Hi all. I know i can use this formula =IF(ISNA(VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)),"",VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)) in the below list to find the number 3. dog 1 cat 2 tophat 3 cow 4 pig 5 But how would i be able to find the number 3 doing this...

Hi Im stuck on how to achieve this so any input would be appreciated. I have imported the data from tables in Word and I need to clean and sort it. Its a fair bit of data (50,000 rows). The imported data is set out as per below: <colgroup><col><col><col><col></colgroup><tbody> CEMETERIES AND...

I'm working with a rather long list that I'm trying to add to the end of a spreadsheet. I know there are formula's out there that can go to the next empty cell in a row or a column, but I need a vba code that can go to the next empty cell in a row based on the first column's value. For example...

Hello. To keep it simple, if column A contains the letters A-C and column B contains strings, how do I return the correct letter (B) in the cell ??? (D1) when I type dog into C1 please? I believe I need to use an array formula containing SEARCH, INDEX and MATCH. I have to use a formula in this...

I have a macro that searches one of my sheets in excel, let's call the sheet "Keywords". After searching it returns the matches. The Keywords sheet has a bunch of terms like "dog", "small", "big dog", "small white dog", etc. The problem I am having, and wondering if there is a way to teach...

Hello - i am trying to write an equation that counts the number of unique values with a criteria associated with it. Below is an example data set, what I want to count is a number of unique animals (column A) but based on a criteria (column B). Using the below I would want an equation that...

Apologies My brain is not working this Monday morning! Can someone please help and translate the following into a formula :) IF B1 CONTAINS "cat" AND c14= "CR" then display "NA", IF B1 CONTAINS "dog" AND c9 DOES NOT CONTAIN "dog", then display "NA" Otherwise display "1" Many thanks

In cell A1 I have a word, for example CAT In cells B1:B10 I have a list of different words B1 = CAT B2 = SCAT B3 = CATH B4 = SCATHE B5= CATS B6 = DOG B7 = CATHERINE B8 = NOCATCH B9 = HORSE B10 = GIRAFFE What I need a formula please is to look at what is in Cell A1, and return the first result...

Hello, First time poster, long time reader. I'm trying to figure out a way using VBA where a user can specify values in 2 adjacent cells with a quantity in a 3rd cell, hit a button and have it insert the values entered a number of times equal to the quantity specified. Example Input: <tbody>...

Hi there, I have data structured as below with the first value in cell A1. <tbody> Dog Bobby Dog Dave Dog Butch Dog Chip Cat Felix Cat Tabatha Mouse Ruby Mouse Mark </tbody> I would like to set the range B1:B4 to a named range called 'Dog' I would like to set the range B6:B7...

I am trying to make a macro that will take take information from a column in sheet1, and create multiple columns in sheet2 with the unique values as titles. Ex: Sheet 1 Column a contains values of: Dog, Cat, Dog, Pony... I need Sheet 2 to have 3 columns titled for each unique value (Dog...

Hello, I'm working on a file and trying to write a code to replace the text in the first column once I apply a filter to the 2nd column. i.e., I filter column 2 for "Dogs" and need to replace column one (which has text of "cat") with "dogs". I have one row of headers which I would like to...

Hi Just wondered if anyone can help with a formula to count out items in a list based on a count in another range with a criteria. So in the example below the little box says how many to count in total and from the list I wish to count out that many with an added criteria and if more to show...

Hello, I would like to know how to use parent child relationship in excel. In the example below I have Animals : Some are dogs and some are birds... The 2 first columns are improtant to understand as they design the parent-child relationship. Here is the result of this work in an excel format...

Hello everybody The following situation I'm struggling for some time right now, I feel like I'm close to solving it, though I do not succeed. What I want: Let's say that in sheet 1 I have one table containing data, with a header, names and amounts. In sheet 2 I want to lookup the sum of...

In A1 i have: =INDEX(D2:D6,MATCH(LARGE(E2:E6,C2,E2:E6,FALSE)) This formula returns the top most valuable customer (dog). But there is a tie for second place (cat and amy) but it returns Amy Twice. How do i fix this? Ty <tbody> A B C D E Waffle 90 1 Dog 30 Amy 50 2 Cat 50 Amy 50 3 Amy 50...