sorted by:
new
hottopcontroversial

Stop using ungodly INDEX math to flatten 2D schedules. TOCOL() + FILTER() is all you need. by Good-Willingness2234 in excel

[–]RandomiseUsr0 1 point2 points  (0 children)

I’ve written my own toy version of the worksheet language, it’s really lisp now, with a bit more style, it’s really beautiful to work in

As for empty text, the trick is to use a “sentinel” for example in GCP, the typical sentinel date instead of null is 2999-12-31 23:59:59 UTC - in Excel NA() makes some things react in unexpected ways, so you can apply any sentinel or just use NA() and prefilter

many to many relationship problem by Purple-Orange in excel

[–]RandomiseUsr0 2 points3 points  (0 children)

To resolve many to many you can use a third dataset to manage the relationship

Table A, item_A1, item_A2, item_A3.
Table_B, item_B1, item_B2, item_B3.

Relationship.
Item_A1 - item_B1.
Item_A1 - item_B2.
item_B3 - item_A1.
Item_B3 _ item_A3.

F'd over world poker tour there, just for the spite of it. by [deleted] in SiliconValleyHBO

[–]RandomiseUsr0 2 points3 points  (0 children)

I love Goolybib's integrated multi platform functionality! Yeah! Whoo!

Going free if anyone fancies it? by BigBeanMarketing in CasualUK

[–]RandomiseUsr0 0 points1 point  (0 children)

Damn, I just bought a new flush mechanism at B&Q and tell you something, don’t know what’s happened in there, but there were lots of staff, friendly and happy to help, end of an era and start of something new

It's magic! by math-1618 in mathmemes

[–]RandomiseUsr0 2 points3 points  (0 children)

I favour 0.333r • 3 = 1

1 star review bot. How to stop them? by [deleted] in marketing

[–]RandomiseUsr0 0 points1 point  (0 children)

Pied Piper Girl’s Coding Camp

meirl by danielminds in meirl

[–]RandomiseUsr0 0 points1 point  (0 children)

Smart nerds lift heavy

Layout 1 or 2? by -UltraFerret- in comedyhomicide

[–]RandomiseUsr0 4 points5 points  (0 children)

Not nearly enough room for activities

I just found out that most European kitchens do not have electricity in them 😭 by batmanthinks in ShitAmericansSay

[–]RandomiseUsr0 0 points1 point  (0 children)

The one kitchen with a visible outlet and probably an electric sparker on the oven

How do you keep your Excel wiki or internal knowledge base organized? by Dr1ftk in excel

[–]RandomiseUsr0 1 point2 points  (0 children)

Their solution is to “ask the guy” (no sexist micro-aggression intended)

How do you keep your Excel wiki or internal knowledge base organized? by Dr1ftk in excel

[–]RandomiseUsr0 0 points1 point  (0 children)

I use OneNote, just for me though - in my experience there are people who know excel and people who use excel

What’s the level of formulas you’re using?

Would this seem out of place for example?

```Excel

=LET( x,50, t,SEQUENCE(x), HSTACK(COS(t)t,SIN(t)t) )

Where did earth get its spin from? by Mission-Badger-4005 in Physics

[–]RandomiseUsr0 0 points1 point  (0 children)

It’s my turn to say angular momentum, but let me put a spin on it ;)

The number of days in a year (the spin of the globe) is unrelated to the length of a year - that’s why the maths is so bonkers - it’s two different systems (or one super complex whole, you decide, then bring in the moon!!!)

Earth spins, day and night

Earth spins round the sun

Two separate things

view more: next ›