animals

Hello there, SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels. <tbody> Bird 1 Dog 0 Cat 1 </tbody>...

Hi. I wonder if you could help me about a formula I need for an excel file. I suppose it isn't too hard, but my excel knowledge is pretty poor. I'm going to give you an example. To save myself some trouble in explaining what I need (it would be bank-related, specific stuff), the example will be...

Hi, Thanks in advance for looking to help me. I have 5 lists: Animals, Food, Places, Names and Drinks there are 20 things in each list. I need to populate a 5 x 5 grid with random selections from these lists - but there can be no duplicates. Column 1 on the 5x5 grid needs to pick from the...

Just wondering as the title suggests if its possible to have a search cell to place the name of the sheet you want from a specific folder? I have seen you can do a search option within power query, but that will be difficult for others. Essentially, I have a folder that has multiple files and I...

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

The sheet's name is: animals A B 1. lion The lions are beatufil animals. 2. dog Dogland is the home of the animals. I need a VBA code which examines the words in column "A" and notes the first...

Hi, I could use some help finding a specific average from two inputs. Not sure if it can be done, but I have been trying to use sumproduct and its not working out very well. I have a Table setup like so. B1:M1 = Jan, Feb, Mar, Apr, May, Jun, July, Aug, Sep, Oct, Nov, Dec A2= Animals B2:M2 =...