dogs

Hi all, I am trying to figure out the best formula for this problem. My workbook is more complicated, but in a nutshell here is what I'm trying to create a formula for: Data Tab <tbody> ANIMAL COUNT Cats 18 Dogs 245 Rabbits 17 </tbody> Animals tab <tbody> Cats Y Dogs N Bears Y...

Hi Everyone, I am having trouble with an excel project in which I have two columns that I feel could be merged into one. I have designed a database that keeps track of adjectives used to describe dog toys by men and women. I first track the gender of the dog, then the gender of the toy is the...

<tbody> Name Type Clean Data DOGS CATS FRANK -DOG DOG FRANK JEFF JEFF -CAT CAT AMY KELLY KELLY -CAT CAT AMY -DOG DOG </tbody> I'm trying to grasp index, match to work on a spread sheet. All of the other questions I find are not helping all that much...

<tbody> a b c d e f 1 dog dog1 dog 2 dogs Dogs 2 cat cats cat1 cat 2 Cat 3 hamster hamsters hamster1 hamster 2 hamster 4 </tbody> hi all - Happy New Year. I was hoping the Excel guru's on this forum can assist me with my issue. I currently have the...

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 =...

Help greatly appreciated on this. Below is a simple representation of a larger data set. I wish to sort each block of rows by column with the numerical value in Col. B descending from Largest to Smallest. <tbody> Col. A Col.B To give result: Col. A Col.B Birds 9 Dogs 14 Dogs 14...

I have a situation where I have 3 different categories but 4 different formulas. For example, let’s say my categories are Dogs, Cats, and Fish. I will always have Dogs. Sometimes with the Dogs I’ll have Cats; sometimes I’ll have Fish with my Dogs, and sometimes I’ll have Cats AND Fish with my...