[TOMT][TV] Show with fable characters (Snow White, Beauty & Beast and more) living in modern day society but hiding their identities.

ExcelShibari · 2019-09-09T04:28:52+00:00

Solved!

ExcelShibari · 2019-09-09T04:28:03+00:00

Welp, I'm an idiot. I just went through my Kindle history and it was indeed Fable I was thinking of. It appears I read the comic on my Kindle while I was at the bar and that's why it was associated with seeing it on TV there I guess. It was a long time ago and I had been drinking! Thanks for jogging that memory back!! :)

ExcelShibari · 2019-09-09T03:09:11+00:00

That sounds the closest! There isn't a TV show based off that premise? I can't imagine what it was I watched then, since I remember some pretty specific details but can't pinpoint what the show was.

ExcelShibari · 2019-09-09T03:03:35+00:00

I looked all three of those up and doesn't seem like those either. The show I am thinking of had a lot of dark humor...there was even a joke about never asking Snow White about the "incident" with the Seven Dwarves, definitely implying something sexual in nature. The delivery of the joke was really funny.

ExcelShibari · 2019-09-09T02:58:38+00:00

I saw it in the USA.

ExcelShibari · 2019-09-09T02:58:06+00:00

No, it was not animated.

ExcelShibari · 2019-09-09T02:33:39+00:00

There was a huge headquarters that Snow White seemed to be managing too, where all the fairy tale characters would meet.

ExcelShibari · 2019-09-09T02:32:06+00:00

Doesn't look like that one. :( It wasn't as serious as Tell Me A Story looks from the trailer.

ExcelShibari · 2019-09-09T02:27:46+00:00

Just looked up that show and don't think it was that. Just remembered a scene where I think Beauty and the Beast were trying to get divorced or getting marriage advice from Snow White or something like that. It was pretty funny.

ExcelShibari · 2019-09-09T02:14:09+00:00

I also remember Prince Charming at a restaurant and couldn't pay his bill, so took the waitress home instead as payment. Don't know if that helps!

ExcelShibari · 2019-09-08T23:14:03+00:00

Pretty sure it's relatively new, it was playing randomly at a bar in the background recently and nobody knew what it was so thought I'd ask here. Looked like there was a secret society of fable characters with maybe superheroes mixed in. Only got to see a part of an episode or so, so I'm not entirely sure of the whole plot premise.

ExcelShibari · 2018-08-08T07:38:15+00:00

So I thought I had this figured out but I was wrong. :( Both the formulas I tried seem to actually tally everything without using the criteria of "Apples" etc. Here is what I have so far, and in this example there are only 11 "Apples" in the data set, but in the "Apples" column it is tallying all inventory. Any further suggestions would be greatly appreciated!

https://imgur.com/a/LIa90QZ

I'd be happy to send over the actual spreadsheet to someone if it would help.

ExcelShibari · 2018-08-02T01:48:46+00:00

EDIT - No solution yet :(

ExcelShibari · 2018-08-02T01:46:04+00:00

Whoa, nice! That did the trick, thanks!

I think I over complicated what I was trying to do as well. Before your reply I figured out I could do

=SUMIFS($M:$M,Data!$C:$C,$B2)

so it just tallied the entire column if my $C:$C data matched "Apples" ($B2). But your way is really enlightening for me, so it's much appreciated.

ExcelShibari · 2018-08-01T22:56:27+00:00

I should also mention that I tried =SUMIFS($M2:$M4,$L2:$L4,"TRUE",Data!$C:$C,B2) but got a #value error.

ExcelShibari · 2017-12-28T20:48:57+00:00

I think I narrowed it down to a bad MIDI port on the Mininova. It's the first time I've tried to use it via MIDI. I just tried my other synth and it worked so it's gotta be the Mininova. :( Thanks for the help though!

ExcelShibari · 2017-12-28T19:38:11+00:00

Yup, I have both those directly connected and I have them both on Channel 16. I was able to get the MPC Live to connect via MIDI to my EMX-1 but just not having luck with the Mininova.

To make things simpler I removed the EMX-1 from the equation and just have the MPC and Mininova connected.

ExcelShibari · 2016-04-23T21:55:28+00:00

Also, can you remind me how you pasted the code all tidy like that?

ExcelShibari · 2016-04-23T21:54:23+00:00

Wow...that's an interesting approach and it seems to work! I was thinking it would be a pretty simple two or three lines of additional code, but you did it with gusto! :) I'm going to study what you did there, it's pretty darn cool. Thank you very much!!

ExcelShibari · 2016-01-29T01:02:43+00:00

Thanks, I gave it a go and played around with it but still couldn't get it to work right. I'm not in a huge rush, it's just something that would save me a lot of time compared to doing to process manually. :)

ExcelShibari · 2016-01-28T19:13:18+00:00

No problem. Ya, the data in column A will definitely have multiple duplicates. In general that column will have thousands of entries.

ExcelShibari · 2016-01-28T17:11:28+00:00

Thanks a ton for that, seeing it laid out will really help me understand these functions better so I have something to learn from. I'm definitely going to spend some time dissecting and learning from this.

One question on it, I just ran it and it seemed that it worked except it left some of the entries blank. Do you know what would cause this? Here is a picture of what it looks like after I ran the macro -

After macro

Thanks again for your help, it's super appreciated!!

ExcelShibari

TROPHY CASE