cats

Hi, I have a dynamic table that I'm trying to sort by the value of the cells (that have duplicate values) in the first column A. I would start of with this: <tbody> Column A Column B Column C 3 cat Cats Rule#1 3 cat Cats Rule#2 3 cat Cats Rule#3 1 dog Dogs Rule#1 1...

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, I have the below data that I want to sum, but only to a certain point: <tbody> Number of cats 7 8 10 11 12 Cumulative cats 7 15 25 8 0 Cap on the number of cats 33 </tbody> I have information on the number of cats in each house, as can be seen it is 7 in...

Hello all. I am trying to reference in a new Tab a list of all the items that hae an "X" against them I.E. A B <tbody> Cats X Dogs Parrots X Shrimp Pandas X </tbody> instead of...

Hello, I am trying to create a pivot table using data from multiple tabs but am having some issues. If anyone could assist it would be greatly appreciated. Here is the information: I have multiple worksheets (on different days) with the same headers. For example, let's say each worksheet has...

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

Hi, Is there a way to have a formula (not VBA) search for “X” and return multiple results? I made a sample with fake data to illustrate what I’m looking for. <colgroup><col style="width:51pt" width="69" span="9"> </colgroup><tbody> Cats Dogs Sheep Snakes...

Hi, I have an excel doc I want to send to a freelancer to upload onto our website, but can't figure out the specific formula to edit this messy category from Sheet1 into the same categories, Sub Cats, and sub-sub cats in Sheet2. I have about 30 of these all with different formatting but still...