One Weird Trick with Curly Brackets
Discover a unique method to streamline your Google Sheets by using curly brackets in the header for array formulas, enhancing data management without altering output.
we have, in the header , everything we need. The grade, the array formula , and ifs formula . Now, we have just data . Really fun way to clean up your data . In the last video, I showed you this array formula , and I showed you that you only had to put one array formula here. But sometimes we don't even want the array formula in the data area. We actually want this formula in the header. We need to cut this entire array formula out. Command X. We're going to see everything go away. And up here in grade, instead of grade, equals. Curly brackets. In quotes, write grade. I'm going to use a semicolon. Not a comma. Paste the array formula that we wrote in the last video here. And now when I hit enter. We will see the exact same thing as before. We didn't change any of the output. But