Use Excel's TAKE and DROP to make brilliant self-updating lists
Many of the Excel formulas I use for lists require supervision. Sometimes, when I add a new row, something breaks or needs adjusting. TAKE and DROP don't have that problem. These two dynamic-array functions, which make tables expand automatically, let you pull or remove specific rows and columns from a dataset, and they update on their own as your data changes.
What's Your Reaction?
Like
0
Dislike
0
Love
0
Funny
0
Angry
0
Sad
0
Wow
0
