Not everything goes as smoothly as these simple calculations, where the result (underlined twice) emerges quickly.
Satisfaction from a task done depends on its relevance, complexity and on the ratio of outcome/energy invested. Since rarely do these all meet, I find it nice to celebrate when this is the case.
Yesterday, we trying to automate something in excel. It needed to be done, it was not just for myself (or my line of work) and it looked challenging. In the end, I came up with:
filter(TRANSPOSE(filter('Output'!A$2:D$46,'Output'!A2:A46=A2)),
MOD(SEQUENCE(ROWS(
TRANSPOSE(filter('Output'!A$2:D$46,'Output'!A2:A46=A2)))),3)=0)
The code is ugly, but it got the job done. The task had pushed us, but after I solved it, others could go about their business easily. An ideal combination – a hard task solved and people benefiting from it. Cheers to small victories! 🎆🎇🎈
A day later: Congratulations if you saw that the violet argument needs to be anchored! Thanks, Rouxbin!
Žiadne komentáre:
Zverejnenie komentára