A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for […]
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time with technology (since 1997) I found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is […]
This is the answer to an old question: Here is the story behind it: I had a client who calls me every now and then asking the same question: ” Can you please remind me of how I would use an array formula? you know, enter multiple conditions into one SUM function? ” Then I […]
