jake

I have a very large table that includes thousands of rows. Row 1 is the header and I'd like to extrapolate each subsequent row to its own file, keeping the original header, and save each using the entry in column A. Could someone help me with a script to accomplish this? Original table that...

This seems like a simple problem, but I'm stuck. Right now I'm on the verge of a giant, if(and(or statement to look at every possible outcome, but I think there has to be an easier way. I'm assuming this is an array formula of some type, but I am not skilled enough to figure it out. I have a...

Hi, Hoping you can help out with this.. I'll try and explain it as best I can. I have a list of completed certifications which I'd like to map to an overall certification. In the example below, Jake has satisfied the all of the requirements and has been granted the overall certification...

We have one column of information which is 500 lines long. We need a formula to find a specific text we are searching for and then once that text has been found we need to get the cell directly below that which contains a value we need. Any help would be greatly appreciated as we've been stuck...

<tbody> A B C 1 MON TUES 2 12:00 PM 3 12:30 PM 12:30 PM - 3:00 PM ALEX 12:30 PM - 3:00 PM ALEX 4 1:00 PM 5 1:30 PM 6 2:00 PM 7 2:30 PM 8 3:00 PM 3:00 PM - 4:00 PM JAKE 3:00 PM - 4:00 PM JAKE 9 3:30 PM 10 4:00 PM </tbody> The above chart is currently...

Long story short, I'm really having a though time figuring out a code to make this <tbody> Jess Class1 Jake Class2 Zach Class3 Kate Class4 </tbody> Do this <tbody> Jess Class1 Jess Class2 Jess Class3 Jess Class4 Jake Class1 Jake Class2 Jake Class3...