snake

Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...

Hey all, I am trying to set up "draft boards" for a youth sports organization and we run the drafts in standard snake order (see example below). I have to do this multiple times per year for for varying number of teams (sometimes as few as 8, sometimes as many as 22) and it gets tedious...

<tbody> Animal Phobic Rat Yes Snake No Spider Unknown Scorpion Rat ? Snake Rat ? Spider </tbody> Hello, how do I get all instances in Col A of 'Rat' to show in Col B as "yes"? This needs to be dynamic as the Col B could also be "no". I...

I need to hide columns across multiple sheets Setup: (Sheet 1) The filter list is in D16:DX (the list may vary in number) DX+1 value is "Show All" <tbody> D 16 Dog 17 Cat 18 Fish 19 Snake 20 Rat 21 Show All </tbody> OR <tbody> D 16 Dog 17 Cat 18 Snake 19 Show All...

Hi all I have a data sheet and a report sheet. (Data) I need the average (displayed in report column B) of the percentages in data column C, if the value in data column B matches the set values in report column A of results. Example: DATA: <tbody> A B C 1 Date Pet Result 2 2017-06-04...