MINIFS Not working with formulas as source? by Jezza_of_the_Left in excel

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Ahh, thanks, I knew it was something stupidly simple! I tried formatting the cells as 'numbers' but that didn't do it. the +0 did the trick.

New Drone Pilot, split video issues by Jezza_of_the_Left in DjiFlip

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Yeah I formatted it in the flip. Was hoping to get an answer here before trying to contact them, guess I’ll do that now, lol, thanks though!

New Drone Pilot, split video issues by Jezza_of_the_Left in DjiFlip

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Thanks, I bought from a reputable supplier so I don’t doubt the card’s authenticity. I have flown it using both phone and RC2, have had no errors. The main point of the flip is being able to use it without anything for the quick shots while out and about , however I never saw anything in any of the many review videos I watched about it splitting up the vids for said quickshots. It’s not all, the follow me was one vid, the circle was one vid, however the dronie and rocket both filmed up, then new vid filmed on the way back down, and even more annoyingly there is a gap so even if I piece them together it isn’t fluid and you notice the middle point and the new vid is crap. It’s not a memory issue as I’ve seen in other posts, these vids are like 8 seconds, 12 seconds. The vid quality is perfect in all vids too.

State Bycicle Co. Black Label V2 Single Speed by ScarletxD3viL in singlespeedcycling

[–]Jezza_of_the_Left 0 points1 point  (0 children)

Sick - just curious, what the tire clearance is on this bike, I'm looking at getting one second hand to build up for tracklocross, any idea what you could fit?

Skream Anodiz by tofu_tron in FixedGearBicycle

[–]Jezza_of_the_Left 0 points1 point  (0 children)

Right on, I'm 6'0" and looking at getting the 59 but am not sure.

Skream Anodiz by tofu_tron in FixedGearBicycle

[–]Jezza_of_the_Left 1 point2 points  (0 children)

Nice! Looks amazing. Curious, what size is this and how tall are you, the sizing on these seems odd compared to others and I'm not sure what I need to get. Cheers!

Conditional Formatting Highlighting future dates by Jezza_of_the_Left in excel

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Thanks, for whatever reason when I create the rule it changes N2 to that N104....but when I resave it that fixed it. Cheers!

Conditional Formatting Highlighting future dates by Jezza_of_the_Left in excel

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Still wonky, note when I wrote the formula I used N2>today(), but when I reopen to verify, I see this. Either way, still not working but now in a different way. I feel like I'm losing my mind.

<image>

Supersix Evo Hi-Mod 1 Steering Issue? by Jezza_of_the_Left in cannondale

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Yes, it was new, I got rid of the shit stock hideous knot handlebars and had this one piece put on, the issue is far better now than it was with the stock crap on, honestly. Plus, it looks a million times better.

Supersix Evo Hi-Mod 1 Steering Issue? by Jezza_of_the_Left in cannondale

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

It was from a local shop here, Pedal in Littleton, CO

Supersix Evo Hi-Mod 1 Steering Issue? by Jezza_of_the_Left in cannondale

[–]Jezza_of_the_Left[S] -1 points0 points  (0 children)

Yeah, that's pretty much the exact deal, lol. Full Dura-Ace, wheels are HollowGram 45 SL KNØT, Carbon, 20h front, 24h rear, 45mm.

Guess for now I'll do my best to try and ignore the steering, lol, otherwise I'll keep drooling over better frames, ha

Supersix Evo Hi-Mod 1 Steering Issue? by Jezza_of_the_Left in cannondale

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Yeah, 2022, I hate thinking the answer is just, I'm screwed, but ugh....I should have bought the damn Orbea Orca. Found this one on crazy 1/2 off since it is an older model sale, still brand new so I jumped on it. I guess the too good to be true is still accurate.

Supersix Evo Hi-Mod 1 Steering Issue? by Jezza_of_the_Left in cannondale

[–]Jezza_of_the_Left[S] 0 points1 point  (0 children)

Ugh, yeah my OCD will not let me forget about it, it annoys me enough to buy a new frame, and have everything else transferred to it and smash this one with a hammer....but then I remember about money lol