Know some fancier formulas like left/​mid/​right, concatenate, hyperlink
Wait, I thought basic fancier formulas are like =index(.., match(.., .., 0)) I guess https://​​dev.to/​​aprillion/​​self-join-in-sheets-sql-python-and-javascript-2km4 might be a nice toy example if someone wants to practice the lessons from the companion piece 😹
=index(.., match(.., .., 0))
Wait, I thought
basicfancier formulas are like=index(.., match(.., .., 0))
I guess https://​​dev.to/​​aprillion/​​self-join-in-sheets-sql-python-and-javascript-2km4 might be a nice toy example if someone wants to practice the lessons from the companion piece 😹